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.XLA_AAD_UPLOAD_PVT dependencies on FND_APPLICATION

Line 75: FROM fnd_application

71: PRAGMA AUTONOMOUS_TRANSACTION;
72:
73: CURSOR c_app_short_name IS
74: SELECT application_short_name
75: FROM fnd_application
76: WHERE application_id = p_application_id;
77:
78: l_app_short_name VARCHAR2(30);
79: l_req_id INTEGER;

Line 238: , fnd_application_vl fa

234: CURSOR c_invalid_app IS
235: SELECT fa.application_name file_app_name
236: , fa2.application_name resp_app_name
237: FROM xla_aad_loader_defns_t xal
238: , fnd_application_vl fa
239: , fnd_application_vl fa2
240: WHERE xal.staging_amb_context_code = p_staging_context_code
241: AND xal.table_name = 'XLA_AAD'
242: AND xal.application_short_name = fa.application_short_name

Line 239: , fnd_application_vl fa2

235: SELECT fa.application_name file_app_name
236: , fa2.application_name resp_app_name
237: FROM xla_aad_loader_defns_t xal
238: , fnd_application_vl fa
239: , fnd_application_vl fa2
240: WHERE xal.staging_amb_context_code = p_staging_context_code
241: AND xal.table_name = 'XLA_AAD'
242: AND xal.application_short_name = fa.application_short_name
243: AND fa.application_id <> p_application_id

Line 442: LEFT OUTER JOIN fnd_application fap

438:
439: CURSOR c_invalid_app_short_name IS
440: SELECT xal.source_app_short_name app_short_name
441: FROM xla_aad_loader_defns_t xal
442: LEFT OUTER JOIN fnd_application fap
443: ON fap.application_short_name = xal.source_app_short_name
444: WHERE xal.staging_amb_context_code = p_staging_context_code
445: AND xal.source_app_short_name IS NOT NULL
446: AND fap.application_id IS NULL

Line 450: LEFT OUTER JOIN fnd_application fap

446: AND fap.application_id IS NULL
447: UNION
448: SELECT xal.value_source_app_short_name
449: FROM xla_aad_loader_defns_t xal
450: LEFT OUTER JOIN fnd_application fap
451: ON fap.application_short_name = xal.value_source_app_short_name
452: WHERE xal.staging_amb_context_code = p_staging_context_code
453: AND xal.value_source_app_short_name IS NOT NULL
454: AND fap.application_id IS NULL

Line 458: LEFT OUTER JOIN fnd_application fap

454: AND fap.application_id IS NULL
455: UNION
456: SELECT xal.view_app_short_name
457: FROM xla_aad_loader_defns_t xal
458: LEFT OUTER JOIN fnd_application fap
459: ON fap.application_short_name = xal.view_app_short_name
460: WHERE xal.staging_amb_context_code = p_staging_context_code
461: AND xal.view_app_short_name IS NOT NULL
462: AND fap.application_id IS NULL

Line 466: LEFT OUTER JOIN fnd_application fap

462: AND fap.application_id IS NULL
463: UNION
464: SELECT xal.application_short_name
465: FROM xla_aad_loader_defns_t xal
466: LEFT OUTER JOIN fnd_application fap
467: ON fap.application_short_name = xal.application_short_name
468: WHERE xal.staging_amb_context_code = p_staging_context_code
469: AND xal.application_short_name IS NOT NULL
470: AND fap.application_id IS NULL

Line 474: LEFT OUTER JOIN fnd_application fap

470: AND fap.application_id IS NULL
471: UNION
472: SELECT xal.input_source_app_short_name
473: FROM xla_aad_loader_defns_t xal
474: LEFT OUTER JOIN fnd_application fap
475: ON fap.application_short_name = xal.input_source_app_short_name
476: WHERE xal.staging_amb_context_code = p_staging_context_code
477: AND xal.input_source_app_short_name IS NOT NULL
478: AND fap.application_id IS NULL

Line 482: LEFT OUTER JOIN fnd_application fap

478: AND fap.application_id IS NULL
479: UNION
480: SELECT xal.value_segment_rule_appl_sn
481: FROM xla_aad_loader_defns_t xal
482: LEFT OUTER JOIN fnd_application fap
483: ON fap.application_short_name = xal.value_segment_rule_appl_sn
484: WHERE xal.staging_amb_context_code = p_staging_context_code
485: AND xal.value_segment_rule_appl_sn IS NOT NULL
486: AND fap.application_id IS NULL;

Line 929: ,fnd_application fap

925: ,fnd_load_util.owner_id(owner)
926: ,0
927: FROM xla_aad_loader_defns_t xal
928: ,xla_desc_priorities p
929: ,fnd_application fap
930: WHERE fap.application_short_name(+) = xal.source_app_short_name
931: AND p.user_sequence = xal.priority_num
932: AND p.description_type_code = xal.description_type_code
933: AND p.description_code = xal.description_code

Line 1040: ,fnd_application fap

1036: ,fnd_load_util.owner_id(owner)
1037: ,0
1038: FROM xla_aad_loader_defns_t xal
1039: ,xla_desc_priorities p
1040: ,fnd_application fap
1041: ,fnd_application fap2
1042: WHERE fap.application_short_name(+) = xal.source_app_short_name
1043: AND fap2.application_short_name(+)= xal.value_source_app_short_name
1044: AND p.user_sequence = xal.priority_num

Line 1041: ,fnd_application fap2

1037: ,0
1038: FROM xla_aad_loader_defns_t xal
1039: ,xla_desc_priorities p
1040: ,fnd_application fap
1041: ,fnd_application fap2
1042: WHERE fap.application_short_name(+) = xal.source_app_short_name
1043: AND fap2.application_short_name(+)= xal.value_source_app_short_name
1044: AND p.user_sequence = xal.priority_num
1045: AND p.description_type_code = xal.description_type_code

Line 1190: ,fnd_application fap

1186: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1187: ,fnd_load_util.owner_id(owner)
1188: ,0
1189: FROM xla_aad_loader_defns_t xal
1190: ,fnd_application fap
1191: ,fnd_id_flex_structures flex
1192: ,fnd_flex_value_sets val
1193: WHERE fap.application_short_name(+) = xal.view_app_short_name
1194: AND val.flex_value_set_name(+) = xal.flex_value_set_name

Line 1494: ,fnd_application fap

1490: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1491: ,fnd_load_util.owner_id(owner)
1492: ,0
1493: FROM xla_aad_loader_defns_t xal
1494: ,fnd_application fap
1495: WHERE fap.application_short_name(+) = xal.application_short_name
1496: AND table_name = 'XLA_ANALYTICAL_HDRS'
1497: AND staging_amb_context_code = p_staging_context_code;
1498:

Line 1657: ,fnd_application fap

1653: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1654: ,fnd_load_util.owner_id(owner)
1655: ,0
1656: FROM xla_aad_loader_defns_t xal
1657: ,fnd_application fap
1658: ,fnd_application fap2
1659: WHERE fap.application_short_name = xal.application_short_name
1660: AND fap2.application_short_name = xal.source_app_short_name
1661: AND table_name = 'XLA_ANALYTICAL_SOURCES'

Line 1658: ,fnd_application fap2

1654: ,fnd_load_util.owner_id(owner)
1655: ,0
1656: FROM xla_aad_loader_defns_t xal
1657: ,fnd_application fap
1658: ,fnd_application fap2
1659: WHERE fap.application_short_name = xal.application_short_name
1660: AND fap2.application_short_name = xal.source_app_short_name
1661: AND table_name = 'XLA_ANALYTICAL_SOURCES'
1662: AND staging_amb_context_code = p_staging_context_code;

Line 1934: LEFT OUTER JOIN fnd_application fap

1930: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1931: ,fnd_load_util.owner_id(owner)
1932: ,0
1933: FROM xla_aad_loader_defns_t xal
1934: LEFT OUTER JOIN fnd_application fap
1935: ON fap.application_short_name = xal.value_source_app_short_name
1936: LEFT OUTER JOIN fnd_application fap2
1937: ON fap2.application_short_name = xal.input_source_app_short_name
1938: LEFT OUTER JOIN fnd_application fap3

Line 1936: LEFT OUTER JOIN fnd_application fap2

1932: ,0
1933: FROM xla_aad_loader_defns_t xal
1934: LEFT OUTER JOIN fnd_application fap
1935: ON fap.application_short_name = xal.value_source_app_short_name
1936: LEFT OUTER JOIN fnd_application fap2
1937: ON fap2.application_short_name = xal.input_source_app_short_name
1938: LEFT OUTER JOIN fnd_application fap3
1939: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
1940: WHERE table_name = 'XLA_SEG_RULE_DETAILS'

Line 1938: LEFT OUTER JOIN fnd_application fap3

1934: LEFT OUTER JOIN fnd_application fap
1935: ON fap.application_short_name = xal.value_source_app_short_name
1936: LEFT OUTER JOIN fnd_application fap2
1937: ON fap2.application_short_name = xal.input_source_app_short_name
1938: LEFT OUTER JOIN fnd_application fap3
1939: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
1940: WHERE table_name = 'XLA_SEG_RULE_DETAILS'
1941: AND staging_amb_context_code = p_staging_context_code;
1942:

Line 2098: ,fnd_application fap

2094: ,fnd_load_util.owner_id(owner)
2095: ,0
2096: FROM xla_aad_loader_defns_t xal
2097: ,xla_seg_rule_details d
2098: ,fnd_application fap
2099: ,fnd_application fap2
2100: WHERE fap.application_short_name(+) = xal.source_app_short_name
2101: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2102: AND d.user_sequence = xal.user_sequence

Line 2099: ,fnd_application fap2

2095: ,0
2096: FROM xla_aad_loader_defns_t xal
2097: ,xla_seg_rule_details d
2098: ,fnd_application fap
2099: ,fnd_application fap2
2100: WHERE fap.application_short_name(+) = xal.source_app_short_name
2101: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2102: AND d.user_sequence = xal.user_sequence
2103: AND d.segment_rule_type_code = xal.segment_rule_type_code

Line 2317: ,fnd_application fap

2313: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2314: ,fnd_load_util.owner_id(owner)
2315: ,0
2316: FROM xla_aad_loader_defns_t xal
2317: ,fnd_application fap
2318: WHERE fap.application_short_name(+) = xal.source_app_short_name
2319: AND table_name = 'XLA_JLT_ACCT_ATTRS'
2320: AND staging_amb_context_code = p_staging_context_code;
2321:

Line 2385: ,fnd_application fap

2381: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2382: ,fnd_load_util.owner_id(owner)
2383: ,0
2384: FROM xla_aad_loader_defns_t xal
2385: ,fnd_application fap
2386: ,fnd_application fap2
2387: WHERE fap.application_short_name(+) = xal.source_app_short_name
2388: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2389: AND table_name = 'XLA_JLT_CONDITIONS'

Line 2386: ,fnd_application fap2

2382: ,fnd_load_util.owner_id(owner)
2383: ,0
2384: FROM xla_aad_loader_defns_t xal
2385: ,fnd_application fap
2386: ,fnd_application fap2
2387: WHERE fap.application_short_name(+) = xal.source_app_short_name
2388: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2389: AND table_name = 'XLA_JLT_CONDITIONS'
2390: AND staging_amb_context_code = p_staging_context_code;

Line 2646: ,fnd_application fap

2642: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2643: ,fnd_load_util.owner_id(owner)
2644: ,0
2645: FROM xla_aad_loader_defns_t xal
2646: ,fnd_application fap
2647: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
2648: AND xal.table_name = 'XLA_LINE_DEFN_ADR_ASSGNS'
2649: AND xal.staging_amb_context_code = p_staging_context_code;
2650:

Line 2890: , fnd_application fap

2886: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2887: ,fnd_load_util.owner_id(owner)
2888: ,0
2889: FROM xla_aad_loader_defns_t xal
2890: , fnd_application fap
2891: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
2892: AND table_name = 'XLA_MPA_JLT_ADR_ASSGNS'
2893: AND staging_amb_context_code = p_staging_context_code;
2894:

Line 3126: ,fnd_application fap

3122: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3123: ,fnd_load_util.owner_id(owner)
3124: ,0
3125: FROM xla_aad_loader_defns_t xal
3126: ,fnd_application fap
3127: WHERE fap.application_short_name(+) = xal.source_app_short_name
3128: AND table_name = 'XLA_AAD_HDR_ACCT_ATTRS'
3129: AND staging_amb_context_code = p_staging_context_code;
3130:

Line 3417: ,fnd_application fap

3413: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3414: ,fnd_load_util.owner_id(owner)
3415: ,0
3416: FROM xla_aad_loader_defns_t xal
3417: ,fnd_application fap
3418: WHERE fap.application_short_name(+) = xal.application_short_name
3419: AND table_name = 'XLA_STAGING_COMPONENTS_H'
3420: AND staging_amb_context_code = p_staging_context_code;
3421: