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_00707_AAD_S_000019_PKG dependencies on CST_XLA_TRF_PLA_CAT_REF_V

Line 339884: WHEN 8 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339880: WHEN 4 THEN 'CST_XLA_INV_REF_V'
339881: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
339882: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339883: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339884: WHEN 8 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339885: WHEN 9 THEN 'CST_XLA_INV_HEADERS_V'
339886: WHEN 10 THEN 'CST_XLA_INV_HEADERS_V'
339887: WHEN 11 THEN 'CST_XLA_INV_HEADERS_V'
339888: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339890: WHEN 14 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339891: WHEN 15 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339892: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339893: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

Line 339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339891: WHEN 15 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339892: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339893: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

Line 339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339892: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339893: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339900: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'

Line 339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339893: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339900: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'
339901: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'

Line 339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339894: WHEN 18 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339900: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'
339901: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
339902:

Line 339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

339895: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339896: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339897: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339898: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339899: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339900: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'
339901: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
339902:
339903: ELSE null

Line 340034: , CST_XLA_TRF_PLA_CAT_REF_V h7

340030: , CST_XLA_INV_REF_V h3
340031: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340032: , CST_XLA_INV_TXN_TYPES_REF_V h5
340033: , CST_XLA_PLA_CATEGORY_REF_V h6
340034: , CST_XLA_TRF_PLA_CAT_REF_V h7
340035: , fnd_lookup_values fvl85
340036: , fnd_lookup_values fvl114
340037: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
340038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 340361: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

340357: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
340358: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
340359: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340360: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340361: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340362: TYPE t_array_source_27 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
340363: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_HEADERS_V.H_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
340364: TYPE t_array_source_30 IS TABLE OF CST_XLA_INV_HEADERS_V.H_SUBINVENTORY_CODE%TYPE INDEX BY BINARY_INTEGER;
340365: TYPE t_array_source_31 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_SUBINVENTORY%TYPE INDEX BY BINARY_INTEGER;

Line 340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

340367: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340368: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340369: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340370: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;

340368: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340369: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340370: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

340369: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340370: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340377: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;

340370: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340377: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
340378: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;

340371: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340377: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
340378: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
340379:

Line 340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

340372: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
340373: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340374: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340375: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
340376: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
340377: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
340378: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
340379:
340380: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 340496: , CST_XLA_TRF_PLA_CAT_REF_V h7

340492: , CST_XLA_INV_REF_V h3
340493: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340494: , CST_XLA_INV_TXN_TYPES_REF_V h5
340495: , CST_XLA_PLA_CATEGORY_REF_V h6
340496: , CST_XLA_TRF_PLA_CAT_REF_V h7
340497: , fnd_lookup_values fvl85
340498: , fnd_lookup_values fvl114
340499: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
340500: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 390099: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

390095: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
390096: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390097: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390098: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390099: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
390100: WHEN 10 THEN 'CST_XLA_INV_HEADERS_V'
390101: WHEN 11 THEN 'CST_XLA_INV_HEADERS_V'
390102: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
390103: WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'

Line 390109: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

390105: WHEN 15 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390106: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390107: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390108: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390109: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
390110: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
390111: WHEN 21 THEN 'CST_XLA_INV_HEADERS_V'
390112:
390113: ELSE null

Line 390228: , CST_XLA_TRF_PLA_CAT_REF_V h7

390224: , CST_XLA_INV_REF_V h3
390225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390226: , CST_XLA_INV_TXN_TYPES_REF_V h5
390227: , CST_XLA_PLA_CATEGORY_REF_V h6
390228: , CST_XLA_TRF_PLA_CAT_REF_V h7
390229: , fnd_lookup_values fvl85
390230: , fnd_lookup_values fvl114
390231: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
390232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 390551: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

390547: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
390548: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390549: TYPE t_array_source_23 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_ACV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390550: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390551: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
390552: TYPE t_array_source_27 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
390553: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_HEADERS_V.H_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
390554: TYPE t_array_source_30 IS TABLE OF CST_XLA_INV_HEADERS_V.H_SUBINVENTORY_CODE%TYPE INDEX BY BINARY_INTEGER;
390555: TYPE t_array_source_31 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_SUBINVENTORY%TYPE INDEX BY BINARY_INTEGER;

Line 390561: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

390557: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390558: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390559: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390560: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390561: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
390562: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
390563: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
390564:
390565: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 390674: , CST_XLA_TRF_PLA_CAT_REF_V h7

390670: , CST_XLA_INV_REF_V h3
390671: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390672: , CST_XLA_INV_TXN_TYPES_REF_V h5
390673: , CST_XLA_PLA_CATEGORY_REF_V h6
390674: , CST_XLA_TRF_PLA_CAT_REF_V h7
390675: , fnd_lookup_values fvl85
390676: , fnd_lookup_values fvl114
390677: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
390678: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

409944: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409945: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409946: WHEN 19 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409947: WHEN 20 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

Line 409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

409945: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409946: WHEN 19 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409947: WHEN 20 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409953: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'

Line 409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

409946: WHEN 19 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409947: WHEN 20 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409953: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
409954: WHEN 27 THEN 'CST_XLA_INV_HEADERS_V'

Line 409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

409947: WHEN 20 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409953: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
409954: WHEN 27 THEN 'CST_XLA_INV_HEADERS_V'
409955:

Line 409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

409948: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409949: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409950: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409951: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409952: WHEN 25 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
409953: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
409954: WHEN 27 THEN 'CST_XLA_INV_HEADERS_V'
409955:
409956: ELSE null

Line 410095: , CST_XLA_TRF_PLA_CAT_REF_V h7

410091: , CST_XLA_INV_REF_V h3
410092: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410093: , CST_XLA_INV_TXN_TYPES_REF_V h5
410094: , CST_XLA_PLA_CATEGORY_REF_V h6
410095: , CST_XLA_TRF_PLA_CAT_REF_V h7
410096: , fnd_lookup_values fvl85
410097: , fnd_lookup_values fvl114
410098: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
410099: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;

410426: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410427: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410428: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410429: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

410427: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410428: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410429: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410435: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;

410428: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410429: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410435: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
410436: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;

410429: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410435: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
410436: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
410437:

Line 410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

410430: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410431: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410432: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410433: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
410434: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410435: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
410436: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
410437:
410438: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 410559: , CST_XLA_TRF_PLA_CAT_REF_V h7

410555: , CST_XLA_INV_REF_V h3
410556: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410557: , CST_XLA_INV_TXN_TYPES_REF_V h5
410558: , CST_XLA_PLA_CATEGORY_REF_V h6
410559: , CST_XLA_TRF_PLA_CAT_REF_V h7
410560: , fnd_lookup_values fvl85
410561: , fnd_lookup_values fvl114
410562: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
410563: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 414283: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414279: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
414280: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414281: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414282: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414283: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414284: WHEN 10 THEN 'CST_XLA_INV_HEADERS_V'
414285: WHEN 11 THEN 'CST_XLA_INV_HEADERS_V'
414286: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
414287: WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'

Line 414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414289: WHEN 15 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414290: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414291: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414292: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

Line 414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414290: WHEN 16 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414291: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414292: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

Line 414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414291: WHEN 17 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414292: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414299: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'

Line 414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414292: WHEN 18 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414299: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
414300: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'

Line 414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414293: WHEN 19 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414299: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
414300: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
414301:

Line 414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'

414294: WHEN 20 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414295: WHEN 21 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414296: WHEN 22 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414297: WHEN 23 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414298: WHEN 24 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414299: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
414300: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
414301:
414302: ELSE null

Line 414437: , CST_XLA_TRF_PLA_CAT_REF_V h7

414433: , CST_XLA_INV_REF_V h3
414434: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414435: , CST_XLA_INV_TXN_TYPES_REF_V h5
414436: , CST_XLA_PLA_CATEGORY_REF_V h6
414437: , CST_XLA_TRF_PLA_CAT_REF_V h7
414438: , fnd_lookup_values fvl85
414439: , fnd_lookup_values fvl114
414440: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
414441: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 414760: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

414756: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
414757: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414758: TYPE t_array_source_23 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_ACV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414759: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414760: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414761: TYPE t_array_source_27 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
414762: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_HEADERS_V.H_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
414763: TYPE t_array_source_30 IS TABLE OF CST_XLA_INV_HEADERS_V.H_SUBINVENTORY_CODE%TYPE INDEX BY BINARY_INTEGER;
414764: TYPE t_array_source_31 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_SUBINVENTORY%TYPE INDEX BY BINARY_INTEGER;

Line 414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

414766: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414767: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414768: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414769: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;

414767: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414768: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414769: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

414768: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414769: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414776: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;

414769: TYPE t_array_source_45 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414776: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
414777: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;

414770: TYPE t_array_source_47 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414776: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
414777: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
414778:

Line 414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;

414771: TYPE t_array_source_48 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
414772: TYPE t_array_source_49 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_MATERIAL_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414773: TYPE t_array_source_50 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414774: TYPE t_array_source_51 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OUTSIDE_PROCESS_ACCT%TYPE INDEX BY BINARY_INTEGER;
414775: TYPE t_array_source_52 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_OVERHEAD_ACCT%TYPE INDEX BY BINARY_INTEGER;
414776: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
414777: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
414778:
414779: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 414898: , CST_XLA_TRF_PLA_CAT_REF_V h7

414894: , CST_XLA_INV_REF_V h3
414895: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414896: , CST_XLA_INV_TXN_TYPES_REF_V h5
414897: , CST_XLA_PLA_CATEGORY_REF_V h6
414898: , CST_XLA_TRF_PLA_CAT_REF_V h7
414899: , fnd_lookup_values fvl85
414900: , fnd_lookup_values fvl114
414901: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
414902: and xet.event_type_code = C_EVENT_TYPE_CODE