DBA Data[Home] [Help]

APPS.JA_CN_COA_EXPORT_PKG dependencies on GL_STAT_ACCOUNT_UOM

Line 246: l_na_mea GL_STAT_ACCOUNT_UOM.UNIT_OF_MEASURE%TYPE;

242: l_na_sub_flag VARCHAR2(1);
243: l_na_sub_item VARCHAR2(100);
244: l_acc_type_code VARCHAR2(1);
245: l_acc_bal_code VARCHAR2(100);
246: l_na_mea GL_STAT_ACCOUNT_UOM.UNIT_OF_MEASURE%TYPE;
247:
248: l_project_meaning VARCHAR2(100);
249: l_thirdparty_meaning VARCHAR2(100);
250: l_supplier_meaning VARCHAR2(100);

Line 587: ,GL_STAT_ACCOUNT_UOM UOM

583: SELECT DISTINCT
584: nvl(UOM.UNIT_OF_MEASURE, '') acc_uom
585: INTO l_na_mea
586: FROM GL_LEDGERS LEDGER
587: ,GL_STAT_ACCOUNT_UOM UOM
588: WHERE LEDGER.ledger_id = l_ledger_id --using variable l_sob_id
589: AND UOM.CHART_OF_ACCOUNTS_ID = LEDGER.CHART_OF_ACCOUNTS_ID
590: AND UOM.ACCOUNT_SEGMENT_VALUE = l_na_number --using variable l_na_number
591: ;