DBA Data[Home] [Help]

APPS.JA_CN_COA_EXP_PKG dependencies on GL_STAT_ACCOUNT_UOM

Line 481: l_na_mea GL_STAT_ACCOUNT_UOM.UNIT_OF_MEASURE%TYPE;

477: l_na_sub_flag VARCHAR2(1);
478: l_na_sub_item VARCHAR2(100);
479: l_acc_type_code VARCHAR2(1);
480: l_acc_bal_code VARCHAR2(100);
481: l_na_mea GL_STAT_ACCOUNT_UOM.UNIT_OF_MEASURE%TYPE;
482:
483: l_project_meaning VARCHAR2(100);
484: l_thirdparty_meaning VARCHAR2(100);
485: l_supplier_meaning VARCHAR2(100);

Line 935: ,GL_STAT_ACCOUNT_UOM UOM

931: SELECT DISTINCT
932: nvl(UOM.UNIT_OF_MEASURE, '') acc_uom
933: INTO l_na_mea
934: FROM GL_LEDGERS LEDGER
935: ,GL_STAT_ACCOUNT_UOM UOM
936: WHERE LEDGER.ledger_id = l_ledger_id --using variable l_sob_id
937: AND UOM.CHART_OF_ACCOUNTS_ID = LEDGER.CHART_OF_ACCOUNTS_ID
938: AND UOM.ACCOUNT_SEGMENT_VALUE = l_na_number --using variable l_na_number
939: ;