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 402: LEFT OUTER JOIN fnd_id_flex_structures fif

398:
399: CURSOR c_invalid_coa IS
400: SELECT xal.value_ccid_id_flex_struct_code id_flex_struct_code
401: FROM xla_aad_loader_defns_t xal
402: LEFT OUTER JOIN fnd_id_flex_structures fif
403: ON fif.application_id = 101
404: AND fif.id_flex_code = 'GL#'
405: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code
406: WHERE xal.staging_amb_context_code = p_staging_context_code

Line 412: LEFT OUTER JOIN fnd_id_flex_structures fif

408: AND fif.id_flex_structure_code IS NULL
409: UNION
410: SELECT xal.trans_coa_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.trans_coa_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.acct_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.acct_coa_id_flex_struct_code
426: WHERE xal.staging_amb_context_code = p_staging_context_code

Line 808: ,fnd_id_flex_structures flex

804: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
805: ,fnd_load_util.owner_id(owner)
806: ,0
807: FROM xla_aad_loader_defns_t i
808: ,fnd_id_flex_structures flex
809: WHERE flex.application_id(+) = 101
810: AND flex.id_flex_code(+) = 'GL#'
811: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
812: AND table_name = 'XLA_DESCRIPTIONS'

Line 1125: ,fnd_id_flex_structures fif

1121: ,xal.value_ccid_segment28
1122: ,xal.value_ccid_segment29
1123: ,xal.value_ccid_segment30
1124: FROM xla_aad_loader_defns_t xal
1125: ,fnd_id_flex_structures fif
1126: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1127: AND xal.staging_amb_context_code = p_staging_context_code
1128: AND fif.application_id = 101
1129: AND fif.id_flex_code = 'GL#'

Line 1191: ,fnd_id_flex_structures flex

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
1195: AND flex.id_flex_code = 'GL#'

Line 1741: ,fnd_id_flex_structures fif

1737: ,xal.value_ccid_segment28
1738: ,xal.value_ccid_segment29
1739: ,xal.value_ccid_segment30
1740: FROM xla_aad_loader_defns_t xal
1741: ,fnd_id_flex_structures fif
1742: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
1743: AND xal.staging_amb_context_code = p_staging_context_code
1744: AND fif.application_id = 101
1745: AND fif.id_flex_code = 'GL#'

Line 1819: ,fnd_id_flex_structures fift

1815: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1816: ,fnd_load_util.owner_id(owner)
1817: ,0
1818: FROM xla_aad_loader_defns_t xal
1819: ,fnd_id_flex_structures fift
1820: ,fnd_id_flex_structures fifa
1821: ,fnd_flex_value_sets val
1822: WHERE fift.application_id(+) = 101
1823: AND fift.id_flex_code(+) = 'GL#'

Line 1820: ,fnd_id_flex_structures fifa

1816: ,fnd_load_util.owner_id(owner)
1817: ,0
1818: FROM xla_aad_loader_defns_t xal
1819: ,fnd_id_flex_structures fift
1820: ,fnd_id_flex_structures fifa
1821: ,fnd_flex_value_sets val
1822: WHERE fift.application_id(+) = 101
1823: AND fift.id_flex_code(+) = 'GL#'
1824: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2225: ,fnd_id_flex_structures flex

2221: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2222: ,fnd_load_util.owner_id(xal.owner)
2223: ,0
2224: FROM xla_aad_loader_defns_t xal
2225: ,fnd_id_flex_structures flex
2226: ,gl_encumbrance_types get
2227: WHERE flex.application_id(+) = 101
2228: AND flex.id_flex_code(+) = 'GL#'
2229: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2477: ,fnd_id_flex_structures fift

2473: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2474: ,fnd_load_util.owner_id(owner)
2475: ,0
2476: FROM xla_aad_loader_defns_t xal
2477: ,fnd_id_flex_structures fift
2478: ,fnd_id_flex_structures fifa
2479: WHERE fift.application_id(+) = 101
2480: AND fift.id_flex_code(+) = 'GL#'
2481: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 2478: ,fnd_id_flex_structures fifa

2474: ,fnd_load_util.owner_id(owner)
2475: ,0
2476: FROM xla_aad_loader_defns_t xal
2477: ,fnd_id_flex_structures fift
2478: ,fnd_id_flex_structures fifa
2479: WHERE fift.application_id(+) = 101
2480: AND fift.id_flex_code(+) = 'GL#'
2481: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
2482: AND fifa.application_id(+) = 101

Line 2984: ,fnd_id_flex_structures fift

2980: ,fnd_load_util.owner_id(xal.owner)
2981: ,0
2982: FROM xla_aad_loader_defns_t xal
2983: ,xla_product_rules_b xpr
2984: ,fnd_id_flex_structures fift
2985: ,fnd_id_flex_structures fifa
2986: WHERE fift.application_id(+) = 101
2987: AND fift.id_flex_code(+) = 'GL#'
2988: AND fift.id_flex_structure_code(+) = xal.trans_coa_id_flex_struct_code

Line 2985: ,fnd_id_flex_structures fifa

2981: ,0
2982: FROM xla_aad_loader_defns_t xal
2983: ,xla_product_rules_b xpr
2984: ,fnd_id_flex_structures fift
2985: ,fnd_id_flex_structures fifa
2986: WHERE fift.application_id(+) = 101
2987: AND fift.id_flex_code(+) = 'GL#'
2988: AND fift.id_flex_structure_code(+) = xal.trans_coa_id_flex_struct_code
2989: AND fifa.application_id(+) = 101

Line 3290: ,fnd_id_flex_structures fift

3286: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3287: ,fnd_load_util.owner_id(owner)
3288: ,0
3289: FROM xla_aad_loader_defns_t xal
3290: ,fnd_id_flex_structures fift
3291: ,fnd_id_flex_structures fifa
3292: WHERE fift.application_id(+) = 101
3293: AND fift.id_flex_code(+) = 'GL#'
3294: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 3291: ,fnd_id_flex_structures fifa

3287: ,fnd_load_util.owner_id(owner)
3288: ,0
3289: FROM xla_aad_loader_defns_t xal
3290: ,fnd_id_flex_structures fift
3291: ,fnd_id_flex_structures fifa
3292: WHERE fift.application_id(+) = 101
3293: AND fift.id_flex_code(+) = 'GL#'
3294: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
3295: AND fifa.application_id(+) = 101