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 803: ,fnd_load_util.owner_id(owner)

799: ,description_code
800: ,flex.id_flex_num
801: ,i.enabled_flag
802: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
803: ,fnd_load_util.owner_id(owner)
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

Line 805: ,fnd_load_util.owner_id(owner)

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

Line 845: ,fnd_load_util.owner_id(owner)

841: ,name
842: ,description
843: ,USERENV('LANG')
844: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
845: ,fnd_load_util.owner_id(owner)
846: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
847: ,fnd_load_util.owner_id(owner)
848: ,0
849: FROM xla_aad_loader_defns_t xal

Line 847: ,fnd_load_util.owner_id(owner)

843: ,USERENV('LANG')
844: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
845: ,fnd_load_util.owner_id(owner)
846: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
847: ,fnd_load_util.owner_id(owner)
848: ,0
849: FROM xla_aad_loader_defns_t xal
850: ,fnd_languages fl
851: WHERE xal.table_name = 'XLA_DESCRIPTIONS'

Line 881: ,fnd_load_util.owner_id(owner)

877: ,description_code
878: ,xla_desc_priorities_s.nextval
879: ,priority_num
880: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
881: ,fnd_load_util.owner_id(owner)
882: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
883: ,fnd_load_util.owner_id(owner)
884: ,0
885: FROM xla_aad_loader_defns_t

Line 883: ,fnd_load_util.owner_id(owner)

879: ,priority_num
880: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
881: ,fnd_load_util.owner_id(owner)
882: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
883: ,fnd_load_util.owner_id(owner)
884: ,0
885: FROM xla_aad_loader_defns_t
886: WHERE table_name = 'XLA_DESC_PRIORITIES'
887: AND staging_amb_context_code = p_staging_context_code;

Line 923: ,fnd_load_util.owner_id(owner)

919: ,source_code
920: ,flexfield_segment_code
921: ,display_description_flag
922: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
923: ,fnd_load_util.owner_id(owner)
924: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
925: ,fnd_load_util.owner_id(owner)
926: ,0
927: FROM xla_aad_loader_defns_t xal

Line 925: ,fnd_load_util.owner_id(owner)

921: ,display_description_flag
922: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
923: ,fnd_load_util.owner_id(owner)
924: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 963: ,fnd_load_util.owner_id(owner)

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

Line 965: ,fnd_load_util.owner_id(owner)

961: ,USERENV('LANG')
962: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
963: ,fnd_load_util.owner_id(owner)
964: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
965: ,fnd_load_util.owner_id(owner)
966: ,0
967: FROM xla_aad_loader_defns_t xal
968: ,xla_descript_details_b xdd
969: ,xla_desc_priorities xdp

Line 1034: ,fnd_load_util.owner_id(owner)

1030: ,value_constant
1031: ,line_operator_code
1032: ,logical_operator_code
1033: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1034: ,fnd_load_util.owner_id(owner)
1035: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1036: ,fnd_load_util.owner_id(owner)
1037: ,0
1038: FROM xla_aad_loader_defns_t xal

Line 1036: ,fnd_load_util.owner_id(owner)

1032: ,logical_operator_code
1033: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1034: ,fnd_load_util.owner_id(owner)
1035: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 1185: ,fnd_load_util.owner_id(owner)

1181: ,lookup_type
1182: ,NVL(version_num,1)
1183: ,'N'
1184: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1185: ,fnd_load_util.owner_id(owner)
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

Line 1187: ,fnd_load_util.owner_id(owner)

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

Line 1231: ,fnd_load_util.owner_id(owner)

1227: ,name
1228: ,description
1229: ,USERENV('LANG')
1230: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1231: ,fnd_load_util.owner_id(owner)
1232: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1233: ,fnd_load_util.owner_id(owner)
1234: ,0
1235: FROM xla_aad_loader_defns_t xal

Line 1233: ,fnd_load_util.owner_id(owner)

1229: ,USERENV('LANG')
1230: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1231: ,fnd_load_util.owner_id(owner)
1232: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1233: ,fnd_load_util.owner_id(owner)
1234: ,0
1235: FROM xla_aad_loader_defns_t xal
1236: ,fnd_languages fl
1237: WHERE xal.table_name = 'XLA_MAPPING_SETS'

Line 1384: ,fnd_load_util.owner_id(owner)

1380: ,enabled_flag
1381: ,input_value_type_code
1382: ,input_value_constant
1383: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1384: ,fnd_load_util.owner_id(owner)
1385: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1386: ,fnd_load_util.owner_id(owner)
1387: ,0
1388: FROM xla_aad_loader_defns_t xal

Line 1386: ,fnd_load_util.owner_id(owner)

1382: ,input_value_constant
1383: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1384: ,fnd_load_util.owner_id(owner)
1385: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1386: ,fnd_load_util.owner_id(owner)
1387: ,0
1388: FROM xla_aad_loader_defns_t xal
1389: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1390: AND staging_amb_context_code = p_staging_context_code;

Line 1489: ,fnd_load_util.owner_id(owner)

1485: ,criterion_value_code
1486: ,NVL(version_num,1)
1487: ,'N'
1488: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1489: ,fnd_load_util.owner_id(owner)
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

Line 1491: ,fnd_load_util.owner_id(owner)

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

Line 1530: ,fnd_load_util.owner_id(owner)

1526: ,name
1527: ,description
1528: ,USERENV('LANG')
1529: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1530: ,fnd_load_util.owner_id(owner)
1531: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1532: ,fnd_load_util.owner_id(owner)
1533: ,0
1534: FROM xla_aad_loader_defns_t xal

Line 1532: ,fnd_load_util.owner_id(owner)

1528: ,USERENV('LANG')
1529: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1530: ,fnd_load_util.owner_id(owner)
1531: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1532: ,fnd_load_util.owner_id(owner)
1533: ,0
1534: FROM xla_aad_loader_defns_t xal
1535: ,fnd_languages fl
1536: WHERE xal.table_name = 'XLA_ANALYTICAL_HDRS'

Line 1567: ,fnd_load_util.owner_id(owner)

1563: ,analytical_detail_code
1564: ,data_type_code
1565: ,grouping_order
1566: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1567: ,fnd_load_util.owner_id(owner)
1568: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1569: ,fnd_load_util.owner_id(owner)
1570: ,0
1571: FROM xla_aad_loader_defns_t xal

Line 1569: ,fnd_load_util.owner_id(owner)

1565: ,grouping_order
1566: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1567: ,fnd_load_util.owner_id(owner)
1568: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1569: ,fnd_load_util.owner_id(owner)
1570: ,0
1571: FROM xla_aad_loader_defns_t xal
1572: WHERE table_name = 'XLA_ANALYTICAL_DTLS'
1573: AND staging_amb_context_code = p_staging_context_code;

Line 1608: ,fnd_load_util.owner_id(owner)

1604: ,name
1605: ,description
1606: ,USERENV('LANG')
1607: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1608: ,fnd_load_util.owner_id(owner)
1609: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1610: ,fnd_load_util.owner_id(owner)
1611: ,0
1612: FROM xla_aad_loader_defns_t xal

Line 1610: ,fnd_load_util.owner_id(owner)

1606: ,USERENV('LANG')
1607: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1608: ,fnd_load_util.owner_id(owner)
1609: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1610: ,fnd_load_util.owner_id(owner)
1611: ,0
1612: FROM xla_aad_loader_defns_t xal
1613: ,fnd_languages fl
1614: WHERE xal.table_name = 'XLA_ANALYTICAL_DTLS'

Line 1652: ,fnd_load_util.owner_id(owner)

1648: ,source_code
1649: ,source_type_code
1650: ,fap2.application_id
1651: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1652: ,fnd_load_util.owner_id(owner)
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

Line 1654: ,fnd_load_util.owner_id(owner)

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

Line 1814: ,fnd_load_util.owner_id(owner)

1810: ,xal.enabled_flag
1811: ,NVL(xal.version_num,1)
1812: ,'N'
1813: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1814: ,fnd_load_util.owner_id(owner)
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

Line 1816: ,fnd_load_util.owner_id(owner)

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

Line 1862: ,fnd_load_util.owner_id(owner)

1858: ,name
1859: ,description
1860: ,USERENV('LANG')
1861: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1862: ,fnd_load_util.owner_id(owner)
1863: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1864: ,fnd_load_util.owner_id(owner)
1865: ,0
1866: FROM xla_aad_loader_defns_t xal

Line 1864: ,fnd_load_util.owner_id(owner)

1860: ,USERENV('LANG')
1861: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1862: ,fnd_load_util.owner_id(owner)
1863: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1864: ,fnd_load_util.owner_id(owner)
1865: ,0
1866: FROM xla_aad_loader_defns_t xal
1867: ,fnd_languages fl
1868: WHERE xal.table_name = 'XLA_SEG_RULES'

Line 1929: ,fnd_load_util.owner_id(owner)

1925: ,fap2.application_id
1926: ,input_source_type_code
1927: ,input_source_code
1928: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1929: ,fnd_load_util.owner_id(owner)
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

Line 1931: ,fnd_load_util.owner_id(owner)

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

Line 2092: ,fnd_load_util.owner_id(owner)

2088: ,xal.value_constant
2089: ,xal.line_operator_code
2090: ,xal.logical_operator_code
2091: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2092: ,fnd_load_util.owner_id(owner)
2093: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2094: ,fnd_load_util.owner_id(owner)
2095: ,0
2096: FROM xla_aad_loader_defns_t xal

Line 2094: ,fnd_load_util.owner_id(owner)

2090: ,xal.logical_operator_code
2091: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2092: ,fnd_load_util.owner_id(owner)
2093: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

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

2216: ,NVL(xal.rounding_class_code,xal.accounting_class_code)
2217: ,get.encumbrance_type_id
2218: ,NVL(xal.mpa_option_code,'NONE')
2219: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2220: ,fnd_load_util.owner_id(xal.owner)
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

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

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

Line 2268: ,fnd_load_util.owner_id(owner)

2264: ,name
2265: ,description
2266: ,USERENV('LANG')
2267: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2268: ,fnd_load_util.owner_id(owner)
2269: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2270: ,fnd_load_util.owner_id(owner)
2271: ,0
2272: FROM xla_aad_loader_defns_t xal

Line 2270: ,fnd_load_util.owner_id(owner)

2266: ,USERENV('LANG')
2267: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2268: ,fnd_load_util.owner_id(owner)
2269: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2270: ,fnd_load_util.owner_id(owner)
2271: ,0
2272: FROM xla_aad_loader_defns_t xal
2273: ,fnd_languages fl
2274: WHERE xal.table_name = 'XLA_ACCT_LINE_TYPES'

Line 2312: ,fnd_load_util.owner_id(owner)

2308: ,source_type_code
2309: ,source_code
2310: ,event_class_default_flag
2311: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2312: ,fnd_load_util.owner_id(owner)
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

Line 2314: ,fnd_load_util.owner_id(owner)

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

Line 2380: ,fnd_load_util.owner_id(owner)

2376: ,value_constant
2377: ,line_operator_code
2378: ,logical_operator_code
2379: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2380: ,fnd_load_util.owner_id(owner)
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

Line 2382: ,fnd_load_util.owner_id(owner)

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

Line 2472: ,fnd_load_util.owner_id(owner)

2468: ,'N'
2469: ,budgetary_control_flag
2470: ,1
2471: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2472: ,fnd_load_util.owner_id(owner)
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

Line 2474: ,fnd_load_util.owner_id(owner)

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

Line 2524: ,fnd_load_util.owner_id(owner)

2520: ,description
2521: ,USERENV('LANG')
2522: ,1
2523: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2524: ,fnd_load_util.owner_id(owner)
2525: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2526: ,fnd_load_util.owner_id(owner)
2527: ,0
2528: FROM xla_aad_loader_defns_t xal

Line 2526: ,fnd_load_util.owner_id(owner)

2522: ,1
2523: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2524: ,fnd_load_util.owner_id(owner)
2525: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2526: ,fnd_load_util.owner_id(owner)
2527: ,0
2528: FROM xla_aad_loader_defns_t xal
2529: ,fnd_languages fl
2530: WHERE xal.table_name = 'XLA_LINE_DEFINITIONS'

Line 2584: ,fnd_load_util.owner_id(owner)

2580: ,mpa_gl_dates_code
2581: ,mpa_proration_code
2582: ,1
2583: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2584: ,fnd_load_util.owner_id(owner)
2585: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2586: ,fnd_load_util.owner_id(owner)
2587: ,0
2588: FROM xla_aad_loader_defns_t

Line 2586: ,fnd_load_util.owner_id(owner)

2582: ,1
2583: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2584: ,fnd_load_util.owner_id(owner)
2585: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2586: ,fnd_load_util.owner_id(owner)
2587: ,0
2588: FROM xla_aad_loader_defns_t
2589: WHERE table_name = 'XLA_LINE_DEFN_JLT_ASSGNS'
2590: AND staging_amb_context_code = p_staging_context_code;

Line 2641: ,fnd_load_util.owner_id(owner)

2637: ,NVL(inherit_adr_flag,'N')
2638: ,NVL(side_code,'NA')
2639: ,1
2640: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2641: ,fnd_load_util.owner_id(owner)
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

Line 2643: ,fnd_load_util.owner_id(owner)

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

Line 2687: ,fnd_load_util.owner_id(owner)

2683: ,analytical_criterion_code
2684: ,analytical_criterion_type_code
2685: ,1
2686: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2687: ,fnd_load_util.owner_id(owner)
2688: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2689: ,fnd_load_util.owner_id(owner)
2690: ,0
2691: FROM xla_aad_loader_defns_t

Line 2689: ,fnd_load_util.owner_id(owner)

2685: ,1
2686: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2687: ,fnd_load_util.owner_id(owner)
2688: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2689: ,fnd_load_util.owner_id(owner)
2690: ,0
2691: FROM xla_aad_loader_defns_t
2692: WHERE table_name = 'XLA_LINE_DEFN_AC_ASSGNS'
2693: AND staging_amb_context_code = p_staging_context_code;

Line 2731: ,fnd_load_util.owner_id(owner)

2727: ,analytical_criterion_code
2728: ,analytical_criterion_type_code
2729: ,1
2730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2731: ,fnd_load_util.owner_id(owner)
2732: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2733: ,fnd_load_util.owner_id(owner)
2734: ,0
2735: FROM xla_aad_loader_defns_t

Line 2733: ,fnd_load_util.owner_id(owner)

2729: ,1
2730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2731: ,fnd_load_util.owner_id(owner)
2732: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2733: ,fnd_load_util.owner_id(owner)
2734: ,0
2735: FROM xla_aad_loader_defns_t
2736: WHERE table_name = 'XLA_MPA_HEADER_AC_ASSGNS'
2737: AND staging_amb_context_code = p_staging_context_code;

Line 2781: ,fnd_load_util.owner_id(owner)

2777: ,description_code
2778: ,inherit_desc_flag
2779: ,1
2780: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2781: ,fnd_load_util.owner_id(owner)
2782: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2783: ,fnd_load_util.owner_id(owner)
2784: ,0
2785: FROM xla_aad_loader_defns_t

Line 2783: ,fnd_load_util.owner_id(owner)

2779: ,1
2780: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2781: ,fnd_load_util.owner_id(owner)
2782: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2783: ,fnd_load_util.owner_id(owner)
2784: ,0
2785: FROM xla_aad_loader_defns_t
2786: WHERE table_name = 'XLA_MPA_JLT_ASSGNS'
2787: AND staging_amb_context_code = p_staging_context_code;

Line 2831: ,fnd_load_util.owner_id(owner)

2827: ,analytical_criterion_code
2828: ,mpa_inherit_ac_flag
2829: ,1
2830: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2831: ,fnd_load_util.owner_id(owner)
2832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2833: ,fnd_load_util.owner_id(owner)
2834: ,0
2835: FROM xla_aad_loader_defns_t

Line 2833: ,fnd_load_util.owner_id(owner)

2829: ,1
2830: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2831: ,fnd_load_util.owner_id(owner)
2832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2833: ,fnd_load_util.owner_id(owner)
2834: ,0
2835: FROM xla_aad_loader_defns_t
2836: WHERE table_name = 'XLA_MPA_JLT_AC_ASSGNS'
2837: AND staging_amb_context_code = p_staging_context_code;

Line 2885: ,fnd_load_util.owner_id(owner)

2881: ,fap.application_id
2882: ,xal.inherit_adr_flag
2883: ,1
2884: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2885: ,fnd_load_util.owner_id(owner)
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

Line 2887: ,fnd_load_util.owner_id(owner)

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

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

2974: ,xpr.product_rule_hash_id
2975: ,NVL(xal.version_num,1)
2976: ,'N'
2977: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2978: ,fnd_load_util.owner_id(xal.owner)
2979: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2980: ,fnd_load_util.owner_id(xal.owner)
2981: ,0
2982: FROM xla_aad_loader_defns_t xal

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

2976: ,'N'
2977: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2978: ,fnd_load_util.owner_id(xal.owner)
2979: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 3029: ,fnd_load_util.owner_id(owner)

3025: ,name
3026: ,description
3027: ,USERENV('LANG')
3028: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3029: ,fnd_load_util.owner_id(owner)
3030: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3031: ,fnd_load_util.owner_id(owner)
3032: ,0
3033: FROM xla_aad_loader_defns_t xal

Line 3031: ,fnd_load_util.owner_id(owner)

3027: ,USERENV('LANG')
3028: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3029: ,fnd_load_util.owner_id(owner)
3030: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3031: ,fnd_load_util.owner_id(owner)
3032: ,0
3033: FROM xla_aad_loader_defns_t xal
3034: ,fnd_languages fl
3035: WHERE xal.table_name = 'XLA_PRODUCT_RULES'

Line 3077: ,fnd_load_util.owner_id(owner)

3073: ,accounting_required_flag
3074: ,locking_status_flag
3075: ,'N'
3076: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3077: ,fnd_load_util.owner_id(owner)
3078: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3079: ,fnd_load_util.owner_id(owner)
3080: ,0
3081: FROM xla_aad_loader_defns_t

Line 3079: ,fnd_load_util.owner_id(owner)

3075: ,'N'
3076: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3077: ,fnd_load_util.owner_id(owner)
3078: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3079: ,fnd_load_util.owner_id(owner)
3080: ,0
3081: FROM xla_aad_loader_defns_t
3082: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'
3083: AND staging_amb_context_code = p_staging_context_code;

Line 3121: ,fnd_load_util.owner_id(owner)

3117: ,source_type_code
3118: ,source_code
3119: ,event_class_default_flag
3120: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3121: ,fnd_load_util.owner_id(owner)
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

Line 3123: ,fnd_load_util.owner_id(owner)

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

Line 3163: ,fnd_load_util.owner_id(owner)

3159: ,line_definition_owner_code
3160: ,line_definition_code
3161: ,1
3162: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3163: ,fnd_load_util.owner_id(owner)
3164: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3165: ,fnd_load_util.owner_id(owner)
3166: ,0
3167: FROM xla_aad_loader_defns_t

Line 3165: ,fnd_load_util.owner_id(owner)

3161: ,1
3162: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3163: ,fnd_load_util.owner_id(owner)
3164: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3165: ,fnd_load_util.owner_id(owner)
3166: ,0
3167: FROM xla_aad_loader_defns_t
3168: WHERE table_name = 'XLA_AAD_LINE_DEFN_ASSGNS'
3169: AND staging_amb_context_code = p_staging_context_code;

Line 3203: ,fnd_load_util.owner_id(owner)

3199: ,analytical_criterion_code
3200: ,analytical_criterion_type_code
3201: ,1
3202: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3203: ,fnd_load_util.owner_id(owner)
3204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3205: ,fnd_load_util.owner_id(owner)
3206: ,0
3207: FROM xla_aad_loader_defns_t

Line 3205: ,fnd_load_util.owner_id(owner)

3201: ,1
3202: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3203: ,fnd_load_util.owner_id(owner)
3204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3205: ,fnd_load_util.owner_id(owner)
3206: ,0
3207: FROM xla_aad_loader_defns_t
3208: WHERE table_name = 'XLA_AAD_HEADER_AC_ASSGNS'
3209: AND staging_amb_context_code = p_staging_context_code;

Line 3285: ,fnd_load_util.owner_id(owner)

3281: ,fifa.id_flex_num
3282: ,xal.enabled_flag
3283: ,1
3284: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3285: ,fnd_load_util.owner_id(owner)
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

Line 3287: ,fnd_load_util.owner_id(owner)

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

Line 3333: ,fnd_load_util.owner_id(owner)

3329: ,product_rule_code
3330: ,start_date_active
3331: ,end_date_active
3332: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3333: ,fnd_load_util.owner_id(owner)
3334: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3335: ,fnd_load_util.owner_id(owner)
3336: ,0
3337: FROM xla_aad_loader_defns_t

Line 3335: ,fnd_load_util.owner_id(owner)

3331: ,end_date_active
3332: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3333: ,fnd_load_util.owner_id(owner)
3334: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3335: ,fnd_load_util.owner_id(owner)
3336: ,0
3337: FROM xla_aad_loader_defns_t
3338: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'
3339: AND staging_amb_context_code = p_staging_context_code;

Line 3412: ,fnd_load_util.owner_id(owner)

3408: ,version_comment
3409: ,leapfrog_flag
3410: ,1
3411: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3412: ,fnd_load_util.owner_id(owner)
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

Line 3414: ,fnd_load_util.owner_id(owner)

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