eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_SUB_ACC_MAPPING

Line 494: SELECT * FROM JA_CN_SUB_ACC_MAPPING SAM,

490: FROM FND_LOOKUP_VALUES FLV
491: WHERE FLV.LOOKUP_TYPE = 'JA_CN_SUB_ACC_SEGMENT'
492: AND FLV.LANGUAGE = USERENV('LANG')
493: AND NOT EXISTS(
494: SELECT * FROM JA_CN_SUB_ACC_MAPPING SAM,
495: GL_LEDGERS LED
496: WHERE SAM.SOURCES_CODE = 'COA'
497: AND SAM.CHART_OF_ACCOUNTS_ID = LED.CHART_OF_ACCOUNTS_ID
498: AND LED.LEDGER_ID = l_Ledger_Id

Line 503: FROM JA_CN_SUB_ACC_MAPPING SAM,

499: AND SAM.SUBSIDIARY_SEGMENT_CODE = FLV.LOOKUP_CODE)
500: UNION
501: SELECT SAM.CONTEXT_CODE,
502: SAM.SUBSIDIARY_SEGMENT_CODE
503: FROM JA_CN_SUB_ACC_MAPPING SAM,
504: GL_LEDGERS LED
505: WHERE SAM.SOURCES_CODE = 'COA'
506: AND SAM.CHART_OF_ACCOUNTS_ID = LED.CHART_OF_ACCOUNTS_ID
507: AND LED.LEDGER_ID = l_Ledger_Id;

Line 977: FROM JA_CN_SUB_ACC_MAPPING SAM

973: CURSOR c_Sub_Segment IS
974: SELECT SAM.SUBSIDIARY_SEGMENT_CODE,
975: SAM.SOURCES_CODE,
976: SAM.CONTEXT_CODE
977: FROM JA_CN_SUB_ACC_MAPPING SAM
978: WHERE SAM.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id;
979:
980: --End: Chaoqun added for CNAOV2 on 01-20-2010
981:

Line 1461: FROM JA_CN_SUB_ACC_MAPPING SAM,

1457: CURSOR c_Sub_Acc_Sources IS
1458: SELECT 'PA' PROJECT_SOURCE_FLAG,
1459: SAM.CONTEXT_CODE PROJECT_AC_CODE,
1460: XADB.GROUPING_ORDER AC_GROUPING_ORDER
1461: FROM JA_CN_SUB_ACC_MAPPING SAM,
1462: XLA_ANALYTICAL_DTLS_B XADB
1463: WHERE XADB.ANALYTICAL_CRITERION_CODE = SAM.CONTEXT_CODE
1464: AND SAM.SOURCES_CODE = 'PROJECT MODULE'
1465: AND SAM.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id;

Line 1473: FROM JA_CN_SUB_ACC_MAPPING SAM

1469: CURSOR c_Sub_Segment IS
1470: SELECT SAM.SUBSIDIARY_SEGMENT_CODE,
1471: SAM.SOURCES_CODE,
1472: SAM.CONTEXT_CODE
1473: FROM JA_CN_SUB_ACC_MAPPING SAM
1474: WHERE SAM.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id;
1475: --End: Chaoqun added for CNAOV2 on 01-20-2010
1476:
1477: BEGIN

Line 1971: FROM JA_CN_SUB_ACC_MAPPING SAM

1967: CURSOR c_Sub_Segment IS
1968: SELECT SAM.SUBSIDIARY_SEGMENT_CODE,
1969: SAM.SOURCES_CODE,
1970: SAM.CONTEXT_CODE
1971: FROM JA_CN_SUB_ACC_MAPPING SAM
1972: WHERE SAM.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id;
1973:
1974:
1975: /* CURSOR c_Project_Option IS