DBA Data[Home] [Help]

APPS.JA_CN_COA_EXP_PKG dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 680: ||' FROM Ja_Cn_Sub_Acc_Sources_All SYS_PAR '

676: ;*/
677: l_sql :=
678: 'SELECT '
679: ||' nvl(ACC_STR_V.concatenated_segments, '''') acc_str '
680: ||' FROM Ja_Cn_Sub_Acc_Sources_All SYS_PAR '
681: ||' ,' || l_account_structures_kfv || ' ACC_STR_V '
682: ||'WHERE ACC_STR_V.account_structure_id = SYS_PAR.ACCOUNTING_STRUCT_ID'
683: ||' AND SYS_PAR.CHART_OF_ACCOUNTS_ID = ' || l_coa_id --using parameter P_LE_ID
684: ;

Line 1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS

1164: BAL.project_number pj_number
1165: ,nvl(FFVT.description, '') pj_name --name for project from COA
1166: FROM JA_CN_ACCOUNT_BALANCES BAL
1167: ,GL_LEDGERS LEDGER
1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS
1169: ,FND_ID_FLEX_SEGMENTS FIFS
1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1171: ,FND_FLEX_VALUE_SETS FFVS
1172: ,FND_FLEX_VALUES_TL FFVT