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 452: LEFT OUTER JOIN fnd_application fap

448:
449: CURSOR c_invalid_app_short_name IS
450: SELECT xal.source_app_short_name app_short_name
451: FROM xla_aad_loader_defns_t xal
452: LEFT OUTER JOIN fnd_application fap
453: ON fap.application_short_name = xal.source_app_short_name
454: WHERE xal.staging_amb_context_code = p_staging_context_code
455: AND xal.source_app_short_name IS NOT NULL
456: AND fap.application_id IS NULL

Line 460: LEFT OUTER JOIN fnd_application fap

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

Line 468: LEFT OUTER JOIN fnd_application fap

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

Line 476: LEFT OUTER JOIN fnd_application fap

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

Line 484: LEFT OUTER JOIN fnd_application fap

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

Line 492: LEFT OUTER JOIN fnd_application fap

488: AND fap.application_id IS NULL
489: UNION
490: SELECT xal.value_segment_rule_appl_sn
491: FROM xla_aad_loader_defns_t xal
492: LEFT OUTER JOIN fnd_application fap
493: ON fap.application_short_name = xal.value_segment_rule_appl_sn
494: WHERE xal.staging_amb_context_code = p_staging_context_code
495: AND xal.value_segment_rule_appl_sn IS NOT NULL
496: AND fap.application_id IS NULL;

Line 1069: ,fnd_application fap

1065: ,fnd_load_util.owner_id(owner)
1066: ,0
1067: FROM xla_aad_loader_defns_t xal
1068: ,xla_desc_priorities p
1069: ,fnd_application fap
1070: WHERE fap.application_short_name(+) = xal.source_app_short_name
1071: AND p.user_sequence = xal.priority_num
1072: AND p.description_type_code = xal.description_type_code
1073: AND p.description_code = xal.description_code

Line 1204: ,fnd_application fap

1200: ,fnd_load_util.owner_id(owner)
1201: ,0
1202: FROM xla_aad_loader_defns_t xal
1203: ,xla_desc_priorities p
1204: ,fnd_application fap
1205: ,fnd_application fap2
1206: WHERE fap.application_short_name(+) = xal.source_app_short_name
1207: AND fap2.application_short_name(+)= xal.value_source_app_short_name
1208: AND p.user_sequence = xal.priority_num

Line 1205: ,fnd_application fap2

1201: ,0
1202: FROM xla_aad_loader_defns_t xal
1203: ,xla_desc_priorities p
1204: ,fnd_application fap
1205: ,fnd_application fap2
1206: WHERE fap.application_short_name(+) = xal.source_app_short_name
1207: AND fap2.application_short_name(+)= xal.value_source_app_short_name
1208: AND p.user_sequence = xal.priority_num
1209: AND p.description_type_code = xal.description_type_code

Line 1387: ,fnd_application fap

1383: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1384: ,fnd_load_util.owner_id(owner)
1385: ,0
1386: FROM xla_aad_loader_defns_t xal
1387: ,fnd_application fap
1388: ,fnd_id_flex_structures flex
1389: ,fnd_flex_value_sets val
1390: ,fnd_flex_value_sets oval -- Added for ER 9395160
1391: WHERE fap.application_short_name(+) = xal.view_app_short_name

Line 1745: ,fnd_application fap

1741: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1742: ,fnd_load_util.owner_id(owner)
1743: ,0
1744: FROM xla_aad_loader_defns_t xal
1745: ,fnd_application fap
1746: WHERE fap.application_short_name(+) = xal.application_short_name
1747: AND table_name = 'XLA_ANALYTICAL_HDRS'
1748: AND staging_amb_context_code = p_staging_context_code;
1749:

Line 1953: ,fnd_application fap

1949: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1950: ,fnd_load_util.owner_id(owner)
1951: ,0
1952: FROM xla_aad_loader_defns_t xal
1953: ,fnd_application fap
1954: ,fnd_application fap2
1955: WHERE fap.application_short_name = xal.application_short_name
1956: AND fap2.application_short_name = xal.source_app_short_name
1957: AND table_name = 'XLA_ANALYTICAL_SOURCES'

Line 1954: ,fnd_application fap2

1950: ,fnd_load_util.owner_id(owner)
1951: ,0
1952: FROM xla_aad_loader_defns_t xal
1953: ,fnd_application fap
1954: ,fnd_application fap2
1955: WHERE fap.application_short_name = xal.application_short_name
1956: AND fap2.application_short_name = xal.source_app_short_name
1957: AND table_name = 'XLA_ANALYTICAL_SOURCES'
1958: AND staging_amb_context_code = p_staging_context_code;

Line 2287: LEFT OUTER JOIN fnd_application fap

2283: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2284: ,fnd_load_util.owner_id(owner)
2285: ,0
2286: FROM xla_aad_loader_defns_t xal
2287: LEFT OUTER JOIN fnd_application fap
2288: ON fap.application_short_name = xal.value_source_app_short_name
2289: LEFT OUTER JOIN fnd_application fap2
2290: ON fap2.application_short_name = xal.input_source_app_short_name
2291: LEFT OUTER JOIN fnd_application fap3

Line 2289: LEFT OUTER JOIN fnd_application fap2

2285: ,0
2286: FROM xla_aad_loader_defns_t xal
2287: LEFT OUTER JOIN fnd_application fap
2288: ON fap.application_short_name = xal.value_source_app_short_name
2289: LEFT OUTER JOIN fnd_application fap2
2290: ON fap2.application_short_name = xal.input_source_app_short_name
2291: LEFT OUTER JOIN fnd_application fap3
2292: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
2293: WHERE table_name = 'XLA_SEG_RULE_DETAILS'

Line 2291: LEFT OUTER JOIN fnd_application fap3

2287: LEFT OUTER JOIN fnd_application fap
2288: ON fap.application_short_name = xal.value_source_app_short_name
2289: LEFT OUTER JOIN fnd_application fap2
2290: ON fap2.application_short_name = xal.input_source_app_short_name
2291: LEFT OUTER JOIN fnd_application fap3
2292: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
2293: WHERE table_name = 'XLA_SEG_RULE_DETAILS'
2294: AND staging_amb_context_code = p_staging_context_code;
2295:

Line 2461: ,fnd_application fap

2457: ,fnd_load_util.owner_id(owner)
2458: ,0
2459: FROM xla_aad_loader_defns_t xal
2460: ,xla_seg_rule_details d
2461: ,fnd_application fap
2462: ,fnd_application fap2
2463: WHERE fap.application_short_name(+) = xal.source_app_short_name
2464: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2465: AND d.user_sequence = xal.user_sequence

Line 2462: ,fnd_application fap2

2458: ,0
2459: FROM xla_aad_loader_defns_t xal
2460: ,xla_seg_rule_details d
2461: ,fnd_application fap
2462: ,fnd_application fap2
2463: WHERE fap.application_short_name(+) = xal.source_app_short_name
2464: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2465: AND d.user_sequence = xal.user_sequence
2466: AND d.segment_rule_type_code = xal.segment_rule_type_code

Line 2734: ,fnd_application fap

2730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2731: ,fnd_load_util.owner_id(owner)
2732: ,0
2733: FROM xla_aad_loader_defns_t xal
2734: ,fnd_application fap
2735: WHERE fap.application_short_name(+) = xal.source_app_short_name
2736: AND table_name = 'XLA_JLT_ACCT_ATTRS'
2737: AND staging_amb_context_code = p_staging_context_code;
2738:

Line 2814: ,fnd_application fap

2810: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2811: ,fnd_load_util.owner_id(owner)
2812: ,0
2813: FROM xla_aad_loader_defns_t xal
2814: ,fnd_application fap
2815: ,fnd_application fap2
2816: WHERE fap.application_short_name(+) = xal.source_app_short_name
2817: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2818: AND table_name = 'XLA_JLT_CONDITIONS'

Line 2815: ,fnd_application fap2

2811: ,fnd_load_util.owner_id(owner)
2812: ,0
2813: FROM xla_aad_loader_defns_t xal
2814: ,fnd_application fap
2815: ,fnd_application fap2
2816: WHERE fap.application_short_name(+) = xal.source_app_short_name
2817: AND fap2.application_short_name(+)= xal.value_source_app_short_name
2818: AND table_name = 'XLA_JLT_CONDITIONS'
2819: AND staging_amb_context_code = p_staging_context_code;

Line 3141: ,fnd_application fap

3137: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3138: ,fnd_load_util.owner_id(owner)
3139: ,0
3140: FROM xla_aad_loader_defns_t xal
3141: ,fnd_application fap
3142: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
3143: AND xal.table_name = 'XLA_LINE_DEFN_ADR_ASSGNS'
3144: AND xal.staging_amb_context_code = p_staging_context_code;
3145:

Line 3437: , fnd_application fap

3433: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3434: ,fnd_load_util.owner_id(owner)
3435: ,0
3436: FROM xla_aad_loader_defns_t xal
3437: , fnd_application fap
3438: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
3439: AND table_name = 'XLA_MPA_JLT_ADR_ASSGNS'
3440: AND staging_amb_context_code = p_staging_context_code;
3441: l_num_rows := SQL%ROWCOUNT;

Line 3734: ,fnd_application fap

3730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3731: ,fnd_load_util.owner_id(owner)
3732: ,0
3733: FROM xla_aad_loader_defns_t xal
3734: ,fnd_application fap
3735: WHERE fap.application_short_name(+) = xal.source_app_short_name
3736: AND table_name = 'XLA_AAD_HDR_ACCT_ATTRS'
3737: AND staging_amb_context_code = p_staging_context_code;
3738:

Line 4117: ,fnd_application fap

4113: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4114: ,fnd_load_util.owner_id(owner)
4115: ,0
4116: FROM xla_aad_loader_defns_t xal
4117: ,fnd_application fap
4118: WHERE fap.application_short_name(+) = xal.application_short_name
4119: AND table_name = 'XLA_STAGING_COMPONENTS_H'
4120: AND staging_amb_context_code = p_staging_context_code;
4121: