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_ID_FLEX_STRUCTURES

Line 412: LEFT OUTER JOIN fnd_id_flex_structures fif

408:
409: CURSOR c_invalid_coa IS
410: SELECT xal.value_ccid_id_flex_struct_code id_flex_struct_code
411: FROM xla_aad_loader_defns_t xal
412: LEFT OUTER JOIN fnd_id_flex_structures fif
413: ON fif.application_id = 101
414: AND fif.id_flex_code = 'GL#'
415: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code
416: WHERE xal.staging_amb_context_code = p_staging_context_code

Line 422: LEFT OUTER JOIN fnd_id_flex_structures fif

418: AND fif.id_flex_structure_code IS NULL
419: UNION
420: SELECT xal.trans_coa_id_flex_struct_code
421: FROM xla_aad_loader_defns_t xal
422: LEFT OUTER JOIN fnd_id_flex_structures fif
423: ON fif.application_id = 101
424: AND fif.id_flex_code = 'GL#'
425: AND fif.id_flex_structure_code = xal.trans_coa_id_flex_struct_code
426: WHERE xal.staging_amb_context_code = p_staging_context_code

Line 432: LEFT OUTER JOIN fnd_id_flex_structures fif

428: AND fif.id_flex_structure_code IS NULL
429: UNION
430: SELECT xal.acct_coa_id_flex_struct_code
431: FROM xla_aad_loader_defns_t xal
432: LEFT OUTER JOIN fnd_id_flex_structures fif
433: ON fif.application_id = 101
434: AND fif.id_flex_code = 'GL#'
435: AND fif.id_flex_structure_code = xal.acct_coa_id_flex_struct_code
436: WHERE xal.staging_amb_context_code = p_staging_context_code

Line 914: ,fnd_id_flex_structures flex

910: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
911: ,fnd_load_util.owner_id(owner)
912: ,0
913: FROM xla_aad_loader_defns_t i
914: ,fnd_id_flex_structures flex
915: WHERE flex.application_id(+) = 101
916: AND flex.id_flex_code(+) = 'GL#'
917: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
918: AND table_name = 'XLA_DESCRIPTIONS'

Line 1318: ,fnd_id_flex_structures fif

1314: ,xal.value_ccid_segment28
1315: ,xal.value_ccid_segment29
1316: ,xal.value_ccid_segment30
1317: FROM xla_aad_loader_defns_t xal
1318: ,fnd_id_flex_structures fif
1319: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1320: AND xal.staging_amb_context_code = p_staging_context_code
1321: AND fif.application_id = 101
1322: AND fif.id_flex_code = 'GL#'

Line 1388: ,fnd_id_flex_structures flex

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
1392: AND val.flex_value_set_name(+) = xal.flex_value_set_name

Line 2067: ,fnd_id_flex_structures fif

2063: ,xal.value_ccid_segment28
2064: ,xal.value_ccid_segment29
2065: ,xal.value_ccid_segment30
2066: FROM xla_aad_loader_defns_t xal
2067: ,fnd_id_flex_structures fif
2068: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
2069: AND xal.staging_amb_context_code = p_staging_context_code
2070: AND fif.application_id = 101
2071: AND fif.id_flex_code = 'GL#'

Line 2148: ,fnd_id_flex_structures fift

2144: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2145: ,fnd_load_util.owner_id(owner)
2146: ,0
2147: FROM xla_aad_loader_defns_t xal
2148: ,fnd_id_flex_structures fift
2149: ,fnd_id_flex_structures fifa
2150: ,fnd_flex_value_sets val
2151: WHERE fift.application_id(+) = 101
2152: AND fift.id_flex_code(+) = 'GL#'

Line 2149: ,fnd_id_flex_structures fifa

2145: ,fnd_load_util.owner_id(owner)
2146: ,0
2147: FROM xla_aad_loader_defns_t xal
2148: ,fnd_id_flex_structures fift
2149: ,fnd_id_flex_structures fifa
2150: ,fnd_flex_value_sets val
2151: WHERE fift.application_id(+) = 101
2152: AND fift.id_flex_code(+) = 'GL#'
2153: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2618: ,fnd_id_flex_structures flex

2614: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2615: ,fnd_load_util.owner_id(xal.owner)
2616: ,0
2617: FROM xla_aad_loader_defns_t xal
2618: ,fnd_id_flex_structures flex
2619: ,gl_encumbrance_types get
2620: WHERE flex.application_id(+) = 101
2621: AND flex.id_flex_code(+) = 'GL#'
2622: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2937: ,fnd_id_flex_structures fift

2933: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2934: ,fnd_load_util.owner_id(owner)
2935: ,0
2936: FROM xla_aad_loader_defns_t xal
2937: ,fnd_id_flex_structures fift
2938: ,fnd_id_flex_structures fifa
2939: WHERE fift.application_id(+) = 101
2940: AND fift.id_flex_code(+) = 'GL#'
2941: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2938: ,fnd_id_flex_structures fifa

2934: ,fnd_load_util.owner_id(owner)
2935: ,0
2936: FROM xla_aad_loader_defns_t xal
2937: ,fnd_id_flex_structures fift
2938: ,fnd_id_flex_structures fifa
2939: WHERE fift.application_id(+) = 101
2940: AND fift.id_flex_code(+) = 'GL#'
2941: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
2942: AND fifa.application_id(+) = 101

Line 3558: ,fnd_id_flex_structures fift

3554: ,fnd_load_util.owner_id(xal.owner)
3555: ,0
3556: FROM xla_aad_loader_defns_t xal
3557: ,xla_product_rules_b xpr
3558: ,fnd_id_flex_structures fift
3559: ,fnd_id_flex_structures fifa
3560: WHERE fift.application_id(+) = 101
3561: AND fift.id_flex_code(+) = 'GL#'
3562: AND fift.id_flex_structure_code(+) = xal.trans_coa_id_flex_struct_code

Line 3559: ,fnd_id_flex_structures fifa

3555: ,0
3556: FROM xla_aad_loader_defns_t xal
3557: ,xla_product_rules_b xpr
3558: ,fnd_id_flex_structures fift
3559: ,fnd_id_flex_structures fifa
3560: WHERE fift.application_id(+) = 101
3561: AND fift.id_flex_code(+) = 'GL#'
3562: AND fift.id_flex_structure_code(+) = xal.trans_coa_id_flex_struct_code
3563: AND fifa.application_id(+) = 101

Line 3948: ,fnd_id_flex_structures fift

3944: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3945: ,fnd_load_util.owner_id(owner)
3946: ,0
3947: FROM xla_aad_loader_defns_t xal
3948: ,fnd_id_flex_structures fift
3949: ,fnd_id_flex_structures fifa
3950: WHERE fift.application_id(+) = 101
3951: AND fift.id_flex_code(+) = 'GL#'
3952: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 3949: ,fnd_id_flex_structures fifa

3945: ,fnd_load_util.owner_id(owner)
3946: ,0
3947: FROM xla_aad_loader_defns_t xal
3948: ,fnd_id_flex_structures fift
3949: ,fnd_id_flex_structures fifa
3950: WHERE fift.application_id(+) = 101
3951: AND fift.id_flex_code(+) = 'GL#'
3952: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
3953: AND fifa.application_id(+) = 101