EBS 中经常用到的一些值集

时间:2021-10-14 23:32:57

名称                                 值集                                                                          默认
=============================================================================================
分类帐标识               GL_SRS_LEDGER_FULL                                                  SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID =  NVL(GL_ACCESS_SET_SECURITY_PKG.GET_DEFAULT_LEDGER_ID(FND_PROFILE.VALUE('GL_ACCESS_SET_ID'),'R'),2021)
日期                        FND_STANDARD_DATE_REQUIRED 或 FND_STANDARD_DATE
期间                        GL_SRS_ALL_PERIODS
访问权限集标识         GL_SRS_NULL_NUM                                                       GL_ACCESS_SET_ID(配置文件)
科目表标识               GL_SRS_COA_UNVALIDATED                                          SELECT CHART_OF_ACCOUNTS_ID FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = :$PROFILES$.GL_ACCESS_SET_ID
分类账/分类账集        GL_SRS_LEDGER_WITH_SETS_STORE_ID                      SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID = GL_ACCESS_SET_SECURITY_PKG.GET_DEFAULT_LEDGER_ID(:$PROFILES$.GL_ACCESS_SET_ID, 'R')
分类账币种               GL_SRS_LEDGER_CURRENCIES_NO_TRANSLATED_ALC    SELECT GL_LEDGER_UTILS_PKG.GET_DEFAULT_LEDGER_CURRENCY(SHORT_NAME) FROM GL_LEDGERS WHERE LEDGER_ID = :$FLEX$.GL_SRS_LEDGER_WITH_SETS_STORE_ID
弹性域对                  GL_SRS_LEDGER_FLEXFIELD
日期范围                  GL_SRS_STANDARD_DATE_LOW - GL_SRS_STANDARD_DATE_HIGH
供应商                     AP_SRS_VENDOR_NAME
业务实体                  FND_MO_OU
发票批                     AP_SRS_BATCH_NAME