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_LOAD_UTIL

Line 909: ,fnd_load_util.owner_id(owner)

905: ,description_code
906: ,flex.id_flex_num
907: ,i.enabled_flag
908: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
909: ,fnd_load_util.owner_id(owner)
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

Line 911: ,fnd_load_util.owner_id(owner)

907: ,i.enabled_flag
908: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
909: ,fnd_load_util.owner_id(owner)
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

Line 961: ,fnd_load_util.owner_id(owner)

957: ,name
958: ,description
959: ,USERENV('LANG')
960: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
961: ,fnd_load_util.owner_id(owner)
962: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
963: ,fnd_load_util.owner_id(owner)
964: ,0
965: FROM xla_aad_loader_defns_t xal

Line 963: ,fnd_load_util.owner_id(owner)

959: ,USERENV('LANG')
960: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
961: ,fnd_load_util.owner_id(owner)
962: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
963: ,fnd_load_util.owner_id(owner)
964: ,0
965: FROM xla_aad_loader_defns_t xal
966: ,fnd_languages fl
967: WHERE xal.table_name = 'XLA_DESCRIPTIONS'

Line 1009: ,fnd_load_util.owner_id(owner)

1005: ,description_code
1006: ,xla_desc_priorities_s.nextval
1007: ,priority_num
1008: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1009: ,fnd_load_util.owner_id(owner)
1010: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1011: ,fnd_load_util.owner_id(owner)
1012: ,0
1013: FROM xla_aad_loader_defns_t

Line 1011: ,fnd_load_util.owner_id(owner)

1007: ,priority_num
1008: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1009: ,fnd_load_util.owner_id(owner)
1010: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1011: ,fnd_load_util.owner_id(owner)
1012: ,0
1013: FROM xla_aad_loader_defns_t
1014: WHERE table_name = 'XLA_DESC_PRIORITIES'
1015: AND staging_amb_context_code = p_staging_context_code;

Line 1063: ,fnd_load_util.owner_id(owner)

1059: ,source_code
1060: ,flexfield_segment_code
1061: ,display_description_flag
1062: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1063: ,fnd_load_util.owner_id(owner)
1064: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1065: ,fnd_load_util.owner_id(owner)
1066: ,0
1067: FROM xla_aad_loader_defns_t xal

Line 1065: ,fnd_load_util.owner_id(owner)

1061: ,display_description_flag
1062: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1063: ,fnd_load_util.owner_id(owner)
1064: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 1115: ,fnd_load_util.owner_id(owner)

1111: ,fl.language_code
1112: ,literal
1113: ,USERENV('LANG')
1114: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1115: ,fnd_load_util.owner_id(owner)
1116: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1117: ,fnd_load_util.owner_id(owner)
1118: ,0
1119: FROM xla_aad_loader_defns_t xal

Line 1117: ,fnd_load_util.owner_id(owner)

1113: ,USERENV('LANG')
1114: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1115: ,fnd_load_util.owner_id(owner)
1116: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1117: ,fnd_load_util.owner_id(owner)
1118: ,0
1119: FROM xla_aad_loader_defns_t xal
1120: ,xla_descript_details_b xdd
1121: ,xla_desc_priorities xdp

Line 1198: ,fnd_load_util.owner_id(owner)

1194: ,value_constant
1195: ,line_operator_code
1196: ,logical_operator_code
1197: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1198: ,fnd_load_util.owner_id(owner)
1199: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1200: ,fnd_load_util.owner_id(owner)
1201: ,0
1202: FROM xla_aad_loader_defns_t xal

Line 1200: ,fnd_load_util.owner_id(owner)

1196: ,logical_operator_code
1197: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1198: ,fnd_load_util.owner_id(owner)
1199: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 1382: ,fnd_load_util.owner_id(owner)

1378: ,lookup_type
1379: ,NVL(version_num,1)
1380: ,'N'
1381: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1382: ,fnd_load_util.owner_id(owner)
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

Line 1384: ,fnd_load_util.owner_id(owner)

1380: ,'N'
1381: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1382: ,fnd_load_util.owner_id(owner)
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

Line 1440: ,fnd_load_util.owner_id(owner)

1436: ,name
1437: ,description
1438: ,USERENV('LANG')
1439: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1440: ,fnd_load_util.owner_id(owner)
1441: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1442: ,fnd_load_util.owner_id(owner)
1443: ,0
1444: FROM xla_aad_loader_defns_t xal

Line 1442: ,fnd_load_util.owner_id(owner)

1438: ,USERENV('LANG')
1439: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1440: ,fnd_load_util.owner_id(owner)
1441: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1442: ,fnd_load_util.owner_id(owner)
1443: ,0
1444: FROM xla_aad_loader_defns_t xal
1445: ,fnd_languages fl
1446: WHERE xal.table_name = 'XLA_MAPPING_SETS'

Line 1605: ,fnd_load_util.owner_id(owner)

1601: ,enabled_flag
1602: ,input_value_type_code
1603: ,input_value_constant
1604: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1605: ,fnd_load_util.owner_id(owner)
1606: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1607: ,fnd_load_util.owner_id(owner)
1608: ,0
1609: FROM xla_aad_loader_defns_t xal

Line 1607: ,fnd_load_util.owner_id(owner)

1603: ,input_value_constant
1604: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1605: ,fnd_load_util.owner_id(owner)
1606: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1607: ,fnd_load_util.owner_id(owner)
1608: ,0
1609: FROM xla_aad_loader_defns_t xal
1610: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1611: AND staging_amb_context_code = p_staging_context_code;

Line 1740: ,fnd_load_util.owner_id(owner)

1736: ,criterion_value_code
1737: ,NVL(version_num,1)
1738: ,'N'
1739: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1740: ,fnd_load_util.owner_id(owner)
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

Line 1742: ,fnd_load_util.owner_id(owner)

1738: ,'N'
1739: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1740: ,fnd_load_util.owner_id(owner)
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

Line 1791: ,fnd_load_util.owner_id(owner)

1787: ,name
1788: ,description
1789: ,USERENV('LANG')
1790: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1791: ,fnd_load_util.owner_id(owner)
1792: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1793: ,fnd_load_util.owner_id(owner)
1794: ,0
1795: FROM xla_aad_loader_defns_t xal

Line 1793: ,fnd_load_util.owner_id(owner)

1789: ,USERENV('LANG')
1790: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1791: ,fnd_load_util.owner_id(owner)
1792: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1793: ,fnd_load_util.owner_id(owner)
1794: ,0
1795: FROM xla_aad_loader_defns_t xal
1796: ,fnd_languages fl
1797: WHERE xal.table_name = 'XLA_ANALYTICAL_HDRS'

Line 1842: ,fnd_load_util.owner_id(owner)

1838: ,analytical_detail_code
1839: ,data_type_code
1840: ,grouping_order
1841: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1842: ,fnd_load_util.owner_id(owner)
1843: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1844: ,fnd_load_util.owner_id(owner)
1845: ,0
1846: FROM xla_aad_loader_defns_t xal

Line 1844: ,fnd_load_util.owner_id(owner)

1840: ,grouping_order
1841: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1842: ,fnd_load_util.owner_id(owner)
1843: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1844: ,fnd_load_util.owner_id(owner)
1845: ,0
1846: FROM xla_aad_loader_defns_t xal
1847: WHERE table_name = 'XLA_ANALYTICAL_DTLS'
1848: AND staging_amb_context_code = p_staging_context_code;

Line 1893: ,fnd_load_util.owner_id(owner)

1889: ,name
1890: ,description
1891: ,USERENV('LANG')
1892: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1893: ,fnd_load_util.owner_id(owner)
1894: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1895: ,fnd_load_util.owner_id(owner)
1896: ,0
1897: FROM xla_aad_loader_defns_t xal

Line 1895: ,fnd_load_util.owner_id(owner)

1891: ,USERENV('LANG')
1892: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1893: ,fnd_load_util.owner_id(owner)
1894: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1895: ,fnd_load_util.owner_id(owner)
1896: ,0
1897: FROM xla_aad_loader_defns_t xal
1898: ,fnd_languages fl
1899: WHERE xal.table_name = 'XLA_ANALYTICAL_DTLS'

Line 1948: ,fnd_load_util.owner_id(owner)

1944: ,source_code
1945: ,source_type_code
1946: ,fap2.application_id
1947: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1948: ,fnd_load_util.owner_id(owner)
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

Line 1950: ,fnd_load_util.owner_id(owner)

1946: ,fap2.application_id
1947: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1948: ,fnd_load_util.owner_id(owner)
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

Line 2143: ,fnd_load_util.owner_id(owner)

2139: ,xal.enabled_flag
2140: ,NVL(xal.version_num,1)
2141: ,'N'
2142: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2143: ,fnd_load_util.owner_id(owner)
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

Line 2145: ,fnd_load_util.owner_id(owner)

2141: ,'N'
2142: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2143: ,fnd_load_util.owner_id(owner)
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

Line 2203: ,fnd_load_util.owner_id(owner)

2199: ,name
2200: ,description
2201: ,USERENV('LANG')
2202: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2203: ,fnd_load_util.owner_id(owner)
2204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2205: ,fnd_load_util.owner_id(owner)
2206: ,0
2207: FROM xla_aad_loader_defns_t xal

Line 2205: ,fnd_load_util.owner_id(owner)

2201: ,USERENV('LANG')
2202: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2203: ,fnd_load_util.owner_id(owner)
2204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2205: ,fnd_load_util.owner_id(owner)
2206: ,0
2207: FROM xla_aad_loader_defns_t xal
2208: ,fnd_languages fl
2209: WHERE xal.table_name = 'XLA_SEG_RULES'

Line 2282: ,fnd_load_util.owner_id(owner)

2278: ,fap2.application_id
2279: ,input_source_type_code
2280: ,input_source_code
2281: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2282: ,fnd_load_util.owner_id(owner)
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

Line 2284: ,fnd_load_util.owner_id(owner)

2280: ,input_source_code
2281: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2282: ,fnd_load_util.owner_id(owner)
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

Line 2455: ,fnd_load_util.owner_id(owner)

2451: ,xal.value_constant
2452: ,xal.line_operator_code
2453: ,xal.logical_operator_code
2454: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2455: ,fnd_load_util.owner_id(owner)
2456: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2457: ,fnd_load_util.owner_id(owner)
2458: ,0
2459: FROM xla_aad_loader_defns_t xal

Line 2457: ,fnd_load_util.owner_id(owner)

2453: ,xal.logical_operator_code
2454: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2455: ,fnd_load_util.owner_id(owner)
2456: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 2613: ,fnd_load_util.owner_id(xal.owner)

2609: ,NVL(xal.rounding_class_code,xal.accounting_class_code)
2610: ,get.encumbrance_type_id
2611: ,NVL(xal.mpa_option_code,'NONE')
2612: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2613: ,fnd_load_util.owner_id(xal.owner)
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

Line 2615: ,fnd_load_util.owner_id(xal.owner)

2611: ,NVL(xal.mpa_option_code,'NONE')
2612: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2613: ,fnd_load_util.owner_id(xal.owner)
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

Line 2673: ,fnd_load_util.owner_id(owner)

2669: ,name
2670: ,description
2671: ,USERENV('LANG')
2672: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2673: ,fnd_load_util.owner_id(owner)
2674: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2675: ,fnd_load_util.owner_id(owner)
2676: ,0
2677: FROM xla_aad_loader_defns_t xal

Line 2675: ,fnd_load_util.owner_id(owner)

2671: ,USERENV('LANG')
2672: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2673: ,fnd_load_util.owner_id(owner)
2674: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2675: ,fnd_load_util.owner_id(owner)
2676: ,0
2677: FROM xla_aad_loader_defns_t xal
2678: ,fnd_languages fl
2679: WHERE xal.table_name = 'XLA_ACCT_LINE_TYPES'

Line 2729: ,fnd_load_util.owner_id(owner)

2725: ,source_type_code
2726: ,source_code
2727: ,event_class_default_flag
2728: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2729: ,fnd_load_util.owner_id(owner)
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

Line 2731: ,fnd_load_util.owner_id(owner)

2727: ,event_class_default_flag
2728: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2729: ,fnd_load_util.owner_id(owner)
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

Line 2809: ,fnd_load_util.owner_id(owner)

2805: ,value_constant
2806: ,line_operator_code
2807: ,logical_operator_code
2808: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2809: ,fnd_load_util.owner_id(owner)
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

Line 2811: ,fnd_load_util.owner_id(owner)

2807: ,logical_operator_code
2808: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2809: ,fnd_load_util.owner_id(owner)
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

Line 2932: ,fnd_load_util.owner_id(owner)

2928: ,'N'
2929: ,budgetary_control_flag
2930: ,1
2931: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2932: ,fnd_load_util.owner_id(owner)
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

Line 2934: ,fnd_load_util.owner_id(owner)

2930: ,1
2931: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2932: ,fnd_load_util.owner_id(owner)
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

Line 2995: ,fnd_load_util.owner_id(owner)

2991: ,description
2992: ,USERENV('LANG')
2993: ,1
2994: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2995: ,fnd_load_util.owner_id(owner)
2996: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2997: ,fnd_load_util.owner_id(owner)
2998: ,0
2999: FROM xla_aad_loader_defns_t xal

Line 2997: ,fnd_load_util.owner_id(owner)

2993: ,1
2994: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2995: ,fnd_load_util.owner_id(owner)
2996: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2997: ,fnd_load_util.owner_id(owner)
2998: ,0
2999: FROM xla_aad_loader_defns_t xal
3000: ,fnd_languages fl
3001: WHERE xal.table_name = 'XLA_LINE_DEFINITIONS'

Line 3067: ,fnd_load_util.owner_id(owner)

3063: ,mpa_gl_dates_code
3064: ,mpa_proration_code
3065: ,1
3066: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3067: ,fnd_load_util.owner_id(owner)
3068: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3069: ,fnd_load_util.owner_id(owner)
3070: ,0
3071: FROM xla_aad_loader_defns_t

Line 3069: ,fnd_load_util.owner_id(owner)

3065: ,1
3066: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3067: ,fnd_load_util.owner_id(owner)
3068: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3069: ,fnd_load_util.owner_id(owner)
3070: ,0
3071: FROM xla_aad_loader_defns_t
3072: WHERE table_name = 'XLA_LINE_DEFN_JLT_ASSGNS'
3073: AND staging_amb_context_code = p_staging_context_code;

Line 3136: ,fnd_load_util.owner_id(owner)

3132: ,NVL(inherit_adr_flag,'N')
3133: ,NVL(side_code,'NA')
3134: ,1
3135: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3136: ,fnd_load_util.owner_id(owner)
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

Line 3138: ,fnd_load_util.owner_id(owner)

3134: ,1
3135: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3136: ,fnd_load_util.owner_id(owner)
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

Line 3193: ,fnd_load_util.owner_id(owner)

3189: ,analytical_criterion_code
3190: ,analytical_criterion_type_code
3191: ,1
3192: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3193: ,fnd_load_util.owner_id(owner)
3194: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3195: ,fnd_load_util.owner_id(owner)
3196: ,0
3197: FROM xla_aad_loader_defns_t

Line 3195: ,fnd_load_util.owner_id(owner)

3191: ,1
3192: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3193: ,fnd_load_util.owner_id(owner)
3194: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3195: ,fnd_load_util.owner_id(owner)
3196: ,0
3197: FROM xla_aad_loader_defns_t
3198: WHERE table_name = 'XLA_LINE_DEFN_AC_ASSGNS'
3199: AND staging_amb_context_code = p_staging_context_code;

Line 3249: ,fnd_load_util.owner_id(owner)

3245: ,analytical_criterion_code
3246: ,analytical_criterion_type_code
3247: ,1
3248: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3249: ,fnd_load_util.owner_id(owner)
3250: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3251: ,fnd_load_util.owner_id(owner)
3252: ,0
3253: FROM xla_aad_loader_defns_t

Line 3251: ,fnd_load_util.owner_id(owner)

3247: ,1
3248: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3249: ,fnd_load_util.owner_id(owner)
3250: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3251: ,fnd_load_util.owner_id(owner)
3252: ,0
3253: FROM xla_aad_loader_defns_t
3254: WHERE table_name = 'XLA_MPA_HEADER_AC_ASSGNS'
3255: AND staging_amb_context_code = p_staging_context_code;

Line 3310: ,fnd_load_util.owner_id(owner)

3306: ,description_code
3307: ,inherit_desc_flag
3308: ,1
3309: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3310: ,fnd_load_util.owner_id(owner)
3311: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3312: ,fnd_load_util.owner_id(owner)
3313: ,0
3314: FROM xla_aad_loader_defns_t

Line 3312: ,fnd_load_util.owner_id(owner)

3308: ,1
3309: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3310: ,fnd_load_util.owner_id(owner)
3311: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3312: ,fnd_load_util.owner_id(owner)
3313: ,0
3314: FROM xla_aad_loader_defns_t
3315: WHERE table_name = 'XLA_MPA_JLT_ASSGNS'
3316: AND staging_amb_context_code = p_staging_context_code;

Line 3370: ,fnd_load_util.owner_id(owner)

3366: ,analytical_criterion_code
3367: ,mpa_inherit_ac_flag
3368: ,1
3369: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3370: ,fnd_load_util.owner_id(owner)
3371: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3372: ,fnd_load_util.owner_id(owner)
3373: ,0
3374: FROM xla_aad_loader_defns_t

Line 3372: ,fnd_load_util.owner_id(owner)

3368: ,1
3369: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3370: ,fnd_load_util.owner_id(owner)
3371: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3372: ,fnd_load_util.owner_id(owner)
3373: ,0
3374: FROM xla_aad_loader_defns_t
3375: WHERE table_name = 'XLA_MPA_JLT_AC_ASSGNS'
3376: AND staging_amb_context_code = p_staging_context_code;

Line 3432: ,fnd_load_util.owner_id(owner)

3428: ,fap.application_id
3429: ,xal.inherit_adr_flag
3430: ,1
3431: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3432: ,fnd_load_util.owner_id(owner)
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

Line 3434: ,fnd_load_util.owner_id(owner)

3430: ,1
3431: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3432: ,fnd_load_util.owner_id(owner)
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

Line 3552: ,fnd_load_util.owner_id(xal.owner)

3548: ,xpr.product_rule_hash_id
3549: ,NVL(xal.version_num,1)
3550: ,'N'
3551: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3552: ,fnd_load_util.owner_id(xal.owner)
3553: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3554: ,fnd_load_util.owner_id(xal.owner)
3555: ,0
3556: FROM xla_aad_loader_defns_t xal

Line 3554: ,fnd_load_util.owner_id(xal.owner)

3550: ,'N'
3551: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3552: ,fnd_load_util.owner_id(xal.owner)
3553: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 3614: ,fnd_load_util.owner_id(owner)

3610: ,name
3611: ,description
3612: ,USERENV('LANG')
3613: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3614: ,fnd_load_util.owner_id(owner)
3615: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3616: ,fnd_load_util.owner_id(owner)
3617: ,0
3618: FROM xla_aad_loader_defns_t xal

Line 3616: ,fnd_load_util.owner_id(owner)

3612: ,USERENV('LANG')
3613: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3614: ,fnd_load_util.owner_id(owner)
3615: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3616: ,fnd_load_util.owner_id(owner)
3617: ,0
3618: FROM xla_aad_loader_defns_t xal
3619: ,fnd_languages fl
3620: WHERE xal.table_name = 'XLA_PRODUCT_RULES'

Line 3674: ,fnd_load_util.owner_id(owner)

3670: ,accounting_required_flag
3671: ,locking_status_flag
3672: ,'N'
3673: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3674: ,fnd_load_util.owner_id(owner)
3675: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3676: ,fnd_load_util.owner_id(owner)
3677: ,0
3678: FROM xla_aad_loader_defns_t

Line 3676: ,fnd_load_util.owner_id(owner)

3672: ,'N'
3673: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3674: ,fnd_load_util.owner_id(owner)
3675: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3676: ,fnd_load_util.owner_id(owner)
3677: ,0
3678: FROM xla_aad_loader_defns_t
3679: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'
3680: AND staging_amb_context_code = p_staging_context_code;

Line 3729: ,fnd_load_util.owner_id(owner)

3725: ,source_type_code
3726: ,source_code
3727: ,event_class_default_flag
3728: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3729: ,fnd_load_util.owner_id(owner)
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

Line 3731: ,fnd_load_util.owner_id(owner)

3727: ,event_class_default_flag
3728: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3729: ,fnd_load_util.owner_id(owner)
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

Line 3782: ,fnd_load_util.owner_id(owner)

3778: ,line_definition_owner_code
3779: ,line_definition_code
3780: ,1
3781: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3782: ,fnd_load_util.owner_id(owner)
3783: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3784: ,fnd_load_util.owner_id(owner)
3785: ,0
3786: FROM xla_aad_loader_defns_t

Line 3784: ,fnd_load_util.owner_id(owner)

3780: ,1
3781: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3782: ,fnd_load_util.owner_id(owner)
3783: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3784: ,fnd_load_util.owner_id(owner)
3785: ,0
3786: FROM xla_aad_loader_defns_t
3787: WHERE table_name = 'XLA_AAD_LINE_DEFN_ASSGNS'
3788: AND staging_amb_context_code = p_staging_context_code;

Line 3831: ,fnd_load_util.owner_id(owner)

3827: ,analytical_criterion_code
3828: ,analytical_criterion_type_code
3829: ,1
3830: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3831: ,fnd_load_util.owner_id(owner)
3832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3833: ,fnd_load_util.owner_id(owner)
3834: ,0
3835: FROM xla_aad_loader_defns_t

Line 3833: ,fnd_load_util.owner_id(owner)

3829: ,1
3830: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3831: ,fnd_load_util.owner_id(owner)
3832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3833: ,fnd_load_util.owner_id(owner)
3834: ,0
3835: FROM xla_aad_loader_defns_t
3836: WHERE table_name = 'XLA_AAD_HEADER_AC_ASSGNS'
3837: AND staging_amb_context_code = p_staging_context_code;

Line 3943: ,fnd_load_util.owner_id(owner)

3939: ,fifa.id_flex_num
3940: ,xal.enabled_flag
3941: ,1
3942: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3943: ,fnd_load_util.owner_id(owner)
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

Line 3945: ,fnd_load_util.owner_id(owner)

3941: ,1
3942: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3943: ,fnd_load_util.owner_id(owner)
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

Line 4001: ,fnd_load_util.owner_id(owner)

3997: ,product_rule_code
3998: ,start_date_active
3999: ,end_date_active
4000: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4001: ,fnd_load_util.owner_id(owner)
4002: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4003: ,fnd_load_util.owner_id(owner)
4004: ,0
4005: FROM xla_aad_loader_defns_t

Line 4003: ,fnd_load_util.owner_id(owner)

3999: ,end_date_active
4000: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4001: ,fnd_load_util.owner_id(owner)
4002: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4003: ,fnd_load_util.owner_id(owner)
4004: ,0
4005: FROM xla_aad_loader_defns_t
4006: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'
4007: AND staging_amb_context_code = p_staging_context_code;

Line 4112: ,fnd_load_util.owner_id(owner)

4108: ,version_comment
4109: ,leapfrog_flag
4110: ,1
4111: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4112: ,fnd_load_util.owner_id(owner)
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

Line 4114: ,fnd_load_util.owner_id(owner)

4110: ,1
4111: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4112: ,fnd_load_util.owner_id(owner)
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