[Home] [Help]
145743: FROM (
145744: SELECT xet.event_id event_id
145745: , 0 line_number
145746: , CASE r
145747: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
145748: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
145749:
145750: ELSE null
145751: END object_name
145744: SELECT xet.event_id event_id
145745: , 0 line_number
145746: , CASE r
145747: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
145748: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
145749:
145750: ELSE null
145751: END object_name
145752: , CASE r
145780:
145781: ELSE null
145782: END source_meaning
145783: FROM xla_events_gt xet
145784: , CST_XLA_INV_HEADERS_V h1
145785: , fnd_lookup_values fvl12
145786: , fnd_lookup_values fvl38
145787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146066: --
146067: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146068: --
146069:
146070: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146071: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
146072:
146073: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
146074: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
146067: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146068: --
146069:
146070: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146071: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
146072:
146073: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
146074: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
146075: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
146128: , fvl12.meaning source_12_meaning
146129: , h1.TRANSFER_TO_GL_INDICATOR source_38
146130: , fvl38.meaning source_38_meaning
146131: FROM xla_events_gt xet
146132: , CST_XLA_INV_HEADERS_V h1
146133: , fnd_lookup_values fvl12
146134: , fnd_lookup_values fvl38
146135: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146136: and xet.event_class_code = C_EVENT_CLASS_CODE
148381: , CASE r
148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'
148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
148393: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
148394:
148395: ELSE null
148396: END object_name
148397: , CASE r
148465:
148466: ELSE null
148467: END source_meaning
148468: FROM xla_events_gt xet
148469: , CST_XLA_INV_HEADERS_V h1
148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148758:
148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
148770: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
148771:
148772: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
148773: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
148774: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
148847: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
148848: , h1.TRANSFER_TO_GL_INDICATOR source_38
148849: , fvl38.meaning source_38_meaning
148850: FROM xla_events_gt xet
148851: , CST_XLA_INV_HEADERS_V h1
148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
149988: FROM (
149989: SELECT xet.event_id event_id
149990: , 0 line_number
149991: , CASE r
149992: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
149993: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
149994:
149995: ELSE null
149996: END object_name
149989: SELECT xet.event_id event_id
149990: , 0 line_number
149991: , CASE r
149992: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
149993: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
149994:
149995: ELSE null
149996: END object_name
149997: , CASE r
150025:
150026: ELSE null
150027: END source_meaning
150028: FROM xla_events_gt xet
150029: , CST_XLA_INV_HEADERS_V h1
150030: , fnd_lookup_values fvl12
150031: , fnd_lookup_values fvl38
150032: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
150033: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150311: --
150312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150313: --
150314:
150315: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150316: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
150317:
150318: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
150319: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
150312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150313: --
150314:
150315: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150316: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
150317:
150318: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
150319: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
150320: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
150373: , fvl12.meaning source_12_meaning
150374: , h1.TRANSFER_TO_GL_INDICATOR source_38
150375: , fvl38.meaning source_38_meaning
150376: FROM xla_events_gt xet
150377: , CST_XLA_INV_HEADERS_V h1
150378: , fnd_lookup_values fvl12
150379: , fnd_lookup_values fvl38
150380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
150381: and xet.event_class_code = C_EVENT_CLASS_CODE
151401: , CASE r
151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'
151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
151413: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
151414:
151415: ELSE null
151416: END object_name
151417: , CASE r
151485:
151486: ELSE null
151487: END source_meaning
151488: FROM xla_events_gt xet
151489: , CST_XLA_INV_HEADERS_V h1
151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151778:
151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
151790: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
151791:
151792: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
151793: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
151794: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151867: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
151868: , h1.TRANSFER_TO_GL_INDICATOR source_38
151869: , fvl38.meaning source_38_meaning
151870: FROM xla_events_gt xet
151871: , CST_XLA_INV_HEADERS_V h1
151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
152969: FROM (
152970: SELECT xet.event_id event_id
152971: , 0 line_number
152972: , CASE r
152973: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
152974: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
152975:
152976: ELSE null
152977: END object_name
152970: SELECT xet.event_id event_id
152971: , 0 line_number
152972: , CASE r
152973: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
152974: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
152975:
152976: ELSE null
152977: END object_name
152978: , CASE r
153006:
153007: ELSE null
153008: END source_meaning
153009: FROM xla_events_gt xet
153010: , CST_XLA_INV_HEADERS_V h1
153011: , fnd_lookup_values fvl12
153012: , fnd_lookup_values fvl38
153013: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153014: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153292: --
153293: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153294: --
153295:
153296: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153297: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
153298:
153299: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
153300: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153293: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153294: --
153295:
153296: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153297: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
153298:
153299: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
153300: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153301: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153354: , fvl12.meaning source_12_meaning
153355: , h1.TRANSFER_TO_GL_INDICATOR source_38
153356: , fvl38.meaning source_38_meaning
153357: FROM xla_events_gt xet
153358: , CST_XLA_INV_HEADERS_V h1
153359: , fnd_lookup_values fvl12
153360: , fnd_lookup_values fvl38
153361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153362: and xet.event_class_code = C_EVENT_CLASS_CODE
154321: FROM (
154322: SELECT xet.event_id event_id
154323: , 0 line_number
154324: , CASE r
154325: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
154326: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
154327:
154328: ELSE null
154329: END object_name
154322: SELECT xet.event_id event_id
154323: , 0 line_number
154324: , CASE r
154325: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
154326: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
154327:
154328: ELSE null
154329: END object_name
154330: , CASE r
154358:
154359: ELSE null
154360: END source_meaning
154361: FROM xla_events_gt xet
154362: , CST_XLA_INV_HEADERS_V h1
154363: , fnd_lookup_values fvl12
154364: , fnd_lookup_values fvl38
154365: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154366: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154644: --
154645: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154646: --
154647:
154648: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
154649: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
154650:
154651: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
154652: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
154645: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154646: --
154647:
154648: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
154649: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
154650:
154651: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
154652: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
154653: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
154706: , fvl12.meaning source_12_meaning
154707: , h1.TRANSFER_TO_GL_INDICATOR source_38
154708: , fvl38.meaning source_38_meaning
154709: FROM xla_events_gt xet
154710: , CST_XLA_INV_HEADERS_V h1
154711: , fnd_lookup_values fvl12
154712: , fnd_lookup_values fvl38
154713: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
154714: and xet.event_class_code = C_EVENT_CLASS_CODE
155560: , CASE r
155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'
155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
155572: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
155573:
155574: ELSE null
155575: END object_name
155576: , CASE r
155644:
155645: ELSE null
155646: END source_meaning
155647: FROM xla_events_gt xet
155648: , CST_XLA_INV_HEADERS_V h1
155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155937:
155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
155949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
155950:
155951: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
155952: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
155953: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156026: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
156027: , h1.TRANSFER_TO_GL_INDICATOR source_38
156028: , fvl38.meaning source_38_meaning
156029: FROM xla_events_gt xet
156030: , CST_XLA_INV_HEADERS_V h1
156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156933: FROM (
156934: SELECT xet.event_id event_id
156935: , 0 line_number
156936: , CASE r
156937: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
156938: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
156939:
156940: ELSE null
156941: END object_name
156934: SELECT xet.event_id event_id
156935: , 0 line_number
156936: , CASE r
156937: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
156938: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
156939:
156940: ELSE null
156941: END object_name
156942: , CASE r
156970:
156971: ELSE null
156972: END source_meaning
156973: FROM xla_events_gt xet
156974: , CST_XLA_INV_HEADERS_V h1
156975: , fnd_lookup_values fvl12
156976: , fnd_lookup_values fvl38
156977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
156978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157256: --
157257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
157258: --
157259:
157260: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157261: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157262:
157263: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157264: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
157258: --
157259:
157260: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157261: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157262:
157263: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157264: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157265: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157318: , fvl12.meaning source_12_meaning
157319: , h1.TRANSFER_TO_GL_INDICATOR source_38
157320: , fvl38.meaning source_38_meaning
157321: FROM xla_events_gt xet
157322: , CST_XLA_INV_HEADERS_V h1
157323: , fnd_lookup_values fvl12
157324: , fnd_lookup_values fvl38
157325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157326: and xet.event_class_code = C_EVENT_CLASS_CODE
158343: FROM (
158344: SELECT xet.event_id event_id
158345: , 0 line_number
158346: , CASE r
158347: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
158348: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
158349:
158350: ELSE null
158351: END object_name
158344: SELECT xet.event_id event_id
158345: , 0 line_number
158346: , CASE r
158347: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
158348: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
158349:
158350: ELSE null
158351: END object_name
158352: , CASE r
158380:
158381: ELSE null
158382: END source_meaning
158383: FROM xla_events_gt xet
158384: , CST_XLA_INV_HEADERS_V h1
158385: , fnd_lookup_values fvl12
158386: , fnd_lookup_values fvl38
158387: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
158388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158666: --
158667: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
158668: --
158669:
158670: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158671: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158672:
158673: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158674: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158667: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
158668: --
158669:
158670: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158671: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158672:
158673: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158674: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158675: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
158728: , fvl12.meaning source_12_meaning
158729: , h1.TRANSFER_TO_GL_INDICATOR source_38
158730: , fvl38.meaning source_38_meaning
158731: FROM xla_events_gt xet
158732: , CST_XLA_INV_HEADERS_V h1
158733: , fnd_lookup_values fvl12
158734: , fnd_lookup_values fvl38
158735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158736: and xet.event_class_code = C_EVENT_CLASS_CODE
159666: FROM (
159667: SELECT xet.event_id event_id
159668: , 0 line_number
159669: , CASE r
159670: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
159671: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
159672:
159673: ELSE null
159674: END object_name
159667: SELECT xet.event_id event_id
159668: , 0 line_number
159669: , CASE r
159670: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
159671: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
159672:
159673: ELSE null
159674: END object_name
159675: , CASE r
159703:
159704: ELSE null
159705: END source_meaning
159706: FROM xla_events_gt xet
159707: , CST_XLA_INV_HEADERS_V h1
159708: , fnd_lookup_values fvl12
159709: , fnd_lookup_values fvl38
159710: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
159711: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159989: --
159990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159991: --
159992:
159993: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
159994: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
159995:
159996: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
159997: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159991: --
159992:
159993: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
159994: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
159995:
159996: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
159997: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159998: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160051: , fvl12.meaning source_12_meaning
160052: , h1.TRANSFER_TO_GL_INDICATOR source_38
160053: , fvl38.meaning source_38_meaning
160054: FROM xla_events_gt xet
160055: , CST_XLA_INV_HEADERS_V h1
160056: , fnd_lookup_values fvl12
160057: , fnd_lookup_values fvl38
160058: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160059: and xet.event_class_code = C_EVENT_CLASS_CODE
160902: FROM (
160903: SELECT xet.event_id event_id
160904: , 0 line_number
160905: , CASE r
160906: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
160907: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
160908:
160909: ELSE null
160910: END object_name
160903: SELECT xet.event_id event_id
160904: , 0 line_number
160905: , CASE r
160906: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
160907: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
160908:
160909: ELSE null
160910: END object_name
160911: , CASE r
160939:
160940: ELSE null
160941: END source_meaning
160942: FROM xla_events_gt xet
160943: , CST_XLA_INV_HEADERS_V h1
160944: , fnd_lookup_values fvl12
160945: , fnd_lookup_values fvl38
160946: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
160947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161225: --
161226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161227: --
161228:
161229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
161231:
161232: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
161233: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
161226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161227: --
161228:
161229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
161231:
161232: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
161233: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
161234: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
161287: , fvl12.meaning source_12_meaning
161288: , h1.TRANSFER_TO_GL_INDICATOR source_38
161289: , fvl38.meaning source_38_meaning
161290: FROM xla_events_gt xet
161291: , CST_XLA_INV_HEADERS_V h1
161292: , fnd_lookup_values fvl12
161293: , fnd_lookup_values fvl38
161294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161295: and xet.event_class_code = C_EVENT_CLASS_CODE
164670: FROM (
164671: SELECT xet.event_id event_id
164672: , 0 line_number
164673: , CASE r
164674: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
164675: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
164676: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
164677:
164678: ELSE null
164671: SELECT xet.event_id event_id
164672: , 0 line_number
164673: , CASE r
164674: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
164675: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
164676: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
164677:
164678: ELSE null
164679: END object_name
164672: , 0 line_number
164673: , CASE r
164674: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
164675: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
164676: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
164677:
164678: ELSE null
164679: END object_name
164680: , CASE r
164713:
164714: ELSE null
164715: END source_meaning
164716: FROM xla_events_gt xet
164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164721: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
165004: --
165005: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165006: --
165007:
165008: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165009: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
165010: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165011:
165012: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
165005: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165006: --
165007:
165008: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165009: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
165010: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165011:
165012: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
165013: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
165006: --
165007:
165008: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165009: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
165010: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165011:
165012: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
165013: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
165014: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165071: , fvl35.meaning source_35_meaning
165072: , h1.TRANSFER_TO_GL_INDICATOR source_38
165073: , fvl38.meaning source_38_meaning
165074: FROM xla_events_gt xet
165075: , CST_XLA_INV_HEADERS_V h1
165076: , fnd_lookup_values fvl12
165077: , fnd_lookup_values fvl35
165078: , fnd_lookup_values fvl38
165079: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165993: FROM (
165994: SELECT xet.event_id event_id
165995: , 0 line_number
165996: , CASE r
165997: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
165998: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
165999:
166000: ELSE null
166001: END object_name
165994: SELECT xet.event_id event_id
165995: , 0 line_number
165996: , CASE r
165997: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
165998: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
165999:
166000: ELSE null
166001: END object_name
166002: , CASE r
166030:
166031: ELSE null
166032: END source_meaning
166033: FROM xla_events_gt xet
166034: , CST_XLA_INV_HEADERS_V h1
166035: , fnd_lookup_values fvl12
166036: , fnd_lookup_values fvl38
166037: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
166038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166316: --
166317: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166318: --
166319:
166320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166321: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166322:
166323: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166324: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166317: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166318: --
166319:
166320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166321: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166322:
166323: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166324: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166325: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166378: , fvl12.meaning source_12_meaning
166379: , h1.TRANSFER_TO_GL_INDICATOR source_38
166380: , fvl38.meaning source_38_meaning
166381: FROM xla_events_gt xet
166382: , CST_XLA_INV_HEADERS_V h1
166383: , fnd_lookup_values fvl12
166384: , fnd_lookup_values fvl38
166385: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166386: and xet.event_class_code = C_EVENT_CLASS_CODE
167200: FROM (
167201: SELECT xet.event_id event_id
167202: , 0 line_number
167203: , CASE r
167204: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
167205: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
167206:
167207: ELSE null
167208: END object_name
167201: SELECT xet.event_id event_id
167202: , 0 line_number
167203: , CASE r
167204: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
167205: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
167206:
167207: ELSE null
167208: END object_name
167209: , CASE r
167237:
167238: ELSE null
167239: END source_meaning
167240: FROM xla_events_gt xet
167241: , CST_XLA_INV_HEADERS_V h1
167242: , fnd_lookup_values fvl12
167243: , fnd_lookup_values fvl38
167244: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
167245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167523: --
167524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
167525: --
167526:
167527: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
167528: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
167529:
167530: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
167531: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
167524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
167525: --
167526:
167527: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
167528: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
167529:
167530: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
167531: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
167532: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
167585: , fvl12.meaning source_12_meaning
167586: , h1.TRANSFER_TO_GL_INDICATOR source_38
167587: , fvl38.meaning source_38_meaning
167588: FROM xla_events_gt xet
167589: , CST_XLA_INV_HEADERS_V h1
167590: , fnd_lookup_values fvl12
167591: , fnd_lookup_values fvl38
167592: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
167593: and xet.event_class_code = C_EVENT_CLASS_CODE
168436: FROM (
168437: SELECT xet.event_id event_id
168438: , 0 line_number
168439: , CASE r
168440: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
168441: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
168442:
168443: ELSE null
168444: END object_name
168437: SELECT xet.event_id event_id
168438: , 0 line_number
168439: , CASE r
168440: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
168441: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
168442:
168443: ELSE null
168444: END object_name
168445: , CASE r
168473:
168474: ELSE null
168475: END source_meaning
168476: FROM xla_events_gt xet
168477: , CST_XLA_INV_HEADERS_V h1
168478: , fnd_lookup_values fvl12
168479: , fnd_lookup_values fvl38
168480: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
168481: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168759: --
168760: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168761: --
168762:
168763: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168764: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168765:
168766: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168767: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168760: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168761: --
168762:
168763: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168764: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168765:
168766: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168767: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168768: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168821: , fvl12.meaning source_12_meaning
168822: , h1.TRANSFER_TO_GL_INDICATOR source_38
168823: , fvl38.meaning source_38_meaning
168824: FROM xla_events_gt xet
168825: , CST_XLA_INV_HEADERS_V h1
168826: , fnd_lookup_values fvl12
168827: , fnd_lookup_values fvl38
168828: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168829: and xet.event_class_code = C_EVENT_CLASS_CODE
172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'
172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'
172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'
172443: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
172444:
172445: ELSE null
172446: END object_name
172447: , CASE r
172515:
172516: ELSE null
172517: END source_meaning
172518: FROM xla_events_gt xet
172519: , CST_XLA_INV_HEADERS_V h1
172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
172820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
172821:
172822: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
172823: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
172824: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
172897: , h3.TXN_PO_DISTRIBUTION_ID source_28
172898: , h1.TRANSFER_TO_GL_INDICATOR source_38
172899: , fvl38.meaning source_38_meaning
172900: FROM xla_events_gt xet
172901: , CST_XLA_INV_HEADERS_V h1
172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
175326: FROM (
175327: SELECT xet.event_id event_id
175328: , 0 line_number
175329: , CASE r
175330: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
175331: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
175332:
175333: ELSE null
175334: END object_name
175327: SELECT xet.event_id event_id
175328: , 0 line_number
175329: , CASE r
175330: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
175331: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
175332:
175333: ELSE null
175334: END object_name
175335: , CASE r
175363:
175364: ELSE null
175365: END source_meaning
175366: FROM xla_events_gt xet
175367: , CST_XLA_INV_HEADERS_V h1
175368: , fnd_lookup_values fvl12
175369: , fnd_lookup_values fvl38
175370: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175649: --
175650: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175651: --
175652:
175653: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175654: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
175655:
175656: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
175657: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
175650: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175651: --
175652:
175653: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175654: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
175655:
175656: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
175657: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
175658: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
175711: , fvl12.meaning source_12_meaning
175712: , h1.TRANSFER_TO_GL_INDICATOR source_38
175713: , fvl38.meaning source_38_meaning
175714: FROM xla_events_gt xet
175715: , CST_XLA_INV_HEADERS_V h1
175716: , fnd_lookup_values fvl12
175717: , fnd_lookup_values fvl38
175718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175719: and xet.event_class_code = C_EVENT_CLASS_CODE
179029: FROM (
179030: SELECT xet.event_id event_id
179031: , 0 line_number
179032: , CASE r
179033: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
179034: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
179035:
179036: ELSE null
179037: END object_name
179030: SELECT xet.event_id event_id
179031: , 0 line_number
179032: , CASE r
179033: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
179034: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
179035:
179036: ELSE null
179037: END object_name
179038: , CASE r
179066:
179067: ELSE null
179068: END source_meaning
179069: FROM xla_events_gt xet
179070: , CST_XLA_INV_HEADERS_V h1
179071: , fnd_lookup_values fvl12
179072: , fnd_lookup_values fvl38
179073: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179074: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179352: --
179353: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
179354: --
179355:
179356: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
179357: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
179358:
179359: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
179360: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
179353: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
179354: --
179355:
179356: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
179357: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
179358:
179359: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
179360: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
179361: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
179414: , fvl12.meaning source_12_meaning
179415: , h1.TRANSFER_TO_GL_INDICATOR source_38
179416: , fvl38.meaning source_38_meaning
179417: FROM xla_events_gt xet
179418: , CST_XLA_INV_HEADERS_V h1
179419: , fnd_lookup_values fvl12
179420: , fnd_lookup_values fvl38
179421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179422: and xet.event_class_code = C_EVENT_CLASS_CODE
180323: FROM (
180324: SELECT xet.event_id event_id
180325: , 0 line_number
180326: , CASE r
180327: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
180328: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
180329:
180330: ELSE null
180331: END object_name
180324: SELECT xet.event_id event_id
180325: , 0 line_number
180326: , CASE r
180327: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
180328: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
180329:
180330: ELSE null
180331: END object_name
180332: , CASE r
180360:
180361: ELSE null
180362: END source_meaning
180363: FROM xla_events_gt xet
180364: , CST_XLA_INV_HEADERS_V h1
180365: , fnd_lookup_values fvl12
180366: , fnd_lookup_values fvl38
180367: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
180368: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180645: --
180646: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180647: --
180648:
180649: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180650: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
180651:
180652: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
180653: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
180646: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180647: --
180648:
180649: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180650: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
180651:
180652: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
180653: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
180654: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
180708: , fvl12.meaning source_12_meaning
180709: , h1.TRANSFER_TO_GL_INDICATOR source_38
180710: , fvl38.meaning source_38_meaning
180711: FROM xla_events_gt xet
180712: , CST_XLA_INV_HEADERS_V h1
180713: , fnd_lookup_values fvl12
180714: , fnd_lookup_values fvl38
180715: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180716: and xet.event_type_code = C_EVENT_TYPE_CODE
181617: FROM (
181618: SELECT xet.event_id event_id
181619: , 0 line_number
181620: , CASE r
181621: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
181622: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
181623:
181624: ELSE null
181625: END object_name
181618: SELECT xet.event_id event_id
181619: , 0 line_number
181620: , CASE r
181621: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
181622: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
181623:
181624: ELSE null
181625: END object_name
181626: , CASE r
181654:
181655: ELSE null
181656: END source_meaning
181657: FROM xla_events_gt xet
181658: , CST_XLA_INV_HEADERS_V h1
181659: , fnd_lookup_values fvl12
181660: , fnd_lookup_values fvl38
181661: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181939: --
181940: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181941: --
181942:
181943: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181944: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
181945:
181946: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
181947: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
181940: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181941: --
181942:
181943: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181944: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
181945:
181946: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
181947: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
181948: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
182002: , fvl12.meaning source_12_meaning
182003: , h1.TRANSFER_TO_GL_INDICATOR source_38
182004: , fvl38.meaning source_38_meaning
182005: FROM xla_events_gt xet
182006: , CST_XLA_INV_HEADERS_V h1
182007: , fnd_lookup_values fvl12
182008: , fnd_lookup_values fvl38
182009: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182010: and xet.event_type_code = C_EVENT_TYPE_CODE
182853: FROM (
182854: SELECT xet.event_id event_id
182855: , 0 line_number
182856: , CASE r
182857: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
182858: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
182859:
182860: ELSE null
182861: END object_name
182854: SELECT xet.event_id event_id
182855: , 0 line_number
182856: , CASE r
182857: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
182858: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
182859:
182860: ELSE null
182861: END object_name
182862: , CASE r
182890:
182891: ELSE null
182892: END source_meaning
182893: FROM xla_events_gt xet
182894: , CST_XLA_INV_HEADERS_V h1
182895: , fnd_lookup_values fvl12
182896: , fnd_lookup_values fvl38
182897: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182898: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183175: --
183176: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183177: --
183178:
183179: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
183180: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
183181:
183182: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
183183: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183176: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183177: --
183178:
183179: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
183180: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
183181:
183182: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
183183: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183184: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183238: , fvl12.meaning source_12_meaning
183239: , h1.TRANSFER_TO_GL_INDICATOR source_38
183240: , fvl38.meaning source_38_meaning
183241: FROM xla_events_gt xet
183242: , CST_XLA_INV_HEADERS_V h1
183243: , fnd_lookup_values fvl12
183244: , fnd_lookup_values fvl38
183245: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183246: and xet.event_type_code = C_EVENT_TYPE_CODE
184263: FROM (
184264: SELECT xet.event_id event_id
184265: , 0 line_number
184266: , CASE r
184267: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
184268: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
184269:
184270: ELSE null
184271: END object_name
184264: SELECT xet.event_id event_id
184265: , 0 line_number
184266: , CASE r
184267: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
184268: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
184269:
184270: ELSE null
184271: END object_name
184272: , CASE r
184300:
184301: ELSE null
184302: END source_meaning
184303: FROM xla_events_gt xet
184304: , CST_XLA_INV_HEADERS_V h1
184305: , fnd_lookup_values fvl12
184306: , fnd_lookup_values fvl38
184307: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
184308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184585: --
184586: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184587: --
184588:
184589: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184590: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
184591:
184592: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
184593: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
184586: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184587: --
184588:
184589: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184590: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
184591:
184592: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
184593: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
184594: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
184648: , fvl12.meaning source_12_meaning
184649: , h1.TRANSFER_TO_GL_INDICATOR source_38
184650: , fvl38.meaning source_38_meaning
184651: FROM xla_events_gt xet
184652: , CST_XLA_INV_HEADERS_V h1
184653: , fnd_lookup_values fvl12
184654: , fnd_lookup_values fvl38
184655: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184656: and xet.event_type_code = C_EVENT_TYPE_CODE
185673: FROM (
185674: SELECT xet.event_id event_id
185675: , 0 line_number
185676: , CASE r
185677: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
185678: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
185679:
185680: ELSE null
185681: END object_name
185674: SELECT xet.event_id event_id
185675: , 0 line_number
185676: , CASE r
185677: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
185678: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
185679:
185680: ELSE null
185681: END object_name
185682: , CASE r
185710:
185711: ELSE null
185712: END source_meaning
185713: FROM xla_events_gt xet
185714: , CST_XLA_INV_HEADERS_V h1
185715: , fnd_lookup_values fvl12
185716: , fnd_lookup_values fvl38
185717: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185995: --
185996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185997: --
185998:
185999: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186000: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
186001:
186002: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
186003: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
185996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185997: --
185998:
185999: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186000: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
186001:
186002: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
186003: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
186004: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
186058: , fvl12.meaning source_12_meaning
186059: , h1.TRANSFER_TO_GL_INDICATOR source_38
186060: , fvl38.meaning source_38_meaning
186061: FROM xla_events_gt xet
186062: , CST_XLA_INV_HEADERS_V h1
186063: , fnd_lookup_values fvl12
186064: , fnd_lookup_values fvl38
186065: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
186066: and xet.event_type_code = C_EVENT_TYPE_CODE
187083: FROM (
187084: SELECT xet.event_id event_id
187085: , 0 line_number
187086: , CASE r
187087: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
187088: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
187089:
187090: ELSE null
187091: END object_name
187084: SELECT xet.event_id event_id
187085: , 0 line_number
187086: , CASE r
187087: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
187088: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
187089:
187090: ELSE null
187091: END object_name
187092: , CASE r
187120:
187121: ELSE null
187122: END source_meaning
187123: FROM xla_events_gt xet
187124: , CST_XLA_INV_HEADERS_V h1
187125: , fnd_lookup_values fvl12
187126: , fnd_lookup_values fvl38
187127: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
187128: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187405: --
187406: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187407: --
187408:
187409: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
187410: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
187411:
187412: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
187413: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187406: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187407: --
187408:
187409: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
187410: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
187411:
187412: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
187413: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187414: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187468: , fvl12.meaning source_12_meaning
187469: , h1.TRANSFER_TO_GL_INDICATOR source_38
187470: , fvl38.meaning source_38_meaning
187471: FROM xla_events_gt xet
187472: , CST_XLA_INV_HEADERS_V h1
187473: , fnd_lookup_values fvl12
187474: , fnd_lookup_values fvl38
187475: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187476: and xet.event_type_code = C_EVENT_TYPE_CODE
188493: FROM (
188494: SELECT xet.event_id event_id
188495: , 0 line_number
188496: , CASE r
188497: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
188498: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
188499:
188500: ELSE null
188501: END object_name
188494: SELECT xet.event_id event_id
188495: , 0 line_number
188496: , CASE r
188497: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
188498: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
188499:
188500: ELSE null
188501: END object_name
188502: , CASE r
188530:
188531: ELSE null
188532: END source_meaning
188533: FROM xla_events_gt xet
188534: , CST_XLA_INV_HEADERS_V h1
188535: , fnd_lookup_values fvl12
188536: , fnd_lookup_values fvl38
188537: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188538: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188815: --
188816: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188817: --
188818:
188819: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
188821:
188822: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
188823: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
188816: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188817: --
188818:
188819: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
188821:
188822: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
188823: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
188824: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
188878: , fvl12.meaning source_12_meaning
188879: , h1.TRANSFER_TO_GL_INDICATOR source_38
188880: , fvl38.meaning source_38_meaning
188881: FROM xla_events_gt xet
188882: , CST_XLA_INV_HEADERS_V h1
188883: , fnd_lookup_values fvl12
188884: , fnd_lookup_values fvl38
188885: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188886: and xet.event_type_code = C_EVENT_TYPE_CODE
189903: FROM (
189904: SELECT xet.event_id event_id
189905: , 0 line_number
189906: , CASE r
189907: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
189908: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
189909:
189910: ELSE null
189911: END object_name
189904: SELECT xet.event_id event_id
189905: , 0 line_number
189906: , CASE r
189907: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
189908: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
189909:
189910: ELSE null
189911: END object_name
189912: , CASE r
189940:
189941: ELSE null
189942: END source_meaning
189943: FROM xla_events_gt xet
189944: , CST_XLA_INV_HEADERS_V h1
189945: , fnd_lookup_values fvl12
189946: , fnd_lookup_values fvl38
189947: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190225: --
190226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190227: --
190228:
190229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
190231:
190232: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
190233: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
190226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190227: --
190228:
190229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
190231:
190232: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
190233: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
190234: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
190288: , fvl12.meaning source_12_meaning
190289: , h1.TRANSFER_TO_GL_INDICATOR source_38
190290: , fvl38.meaning source_38_meaning
190291: FROM xla_events_gt xet
190292: , CST_XLA_INV_HEADERS_V h1
190293: , fnd_lookup_values fvl12
190294: , fnd_lookup_values fvl38
190295: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190296: and xet.event_type_code = C_EVENT_TYPE_CODE
191313: FROM (
191314: SELECT xet.event_id event_id
191315: , 0 line_number
191316: , CASE r
191317: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
191318: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
191319:
191320: ELSE null
191321: END object_name
191314: SELECT xet.event_id event_id
191315: , 0 line_number
191316: , CASE r
191317: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
191318: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
191319:
191320: ELSE null
191321: END object_name
191322: , CASE r
191350:
191351: ELSE null
191352: END source_meaning
191353: FROM xla_events_gt xet
191354: , CST_XLA_INV_HEADERS_V h1
191355: , fnd_lookup_values fvl12
191356: , fnd_lookup_values fvl38
191357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191635: --
191636: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191637: --
191638:
191639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
191640: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
191641:
191642: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
191643: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
191636: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191637: --
191638:
191639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
191640: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
191641:
191642: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
191643: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
191644: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191698: , fvl12.meaning source_12_meaning
191699: , h1.TRANSFER_TO_GL_INDICATOR source_38
191700: , fvl38.meaning source_38_meaning
191701: FROM xla_events_gt xet
191702: , CST_XLA_INV_HEADERS_V h1
191703: , fnd_lookup_values fvl12
191704: , fnd_lookup_values fvl38
191705: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191706: and xet.event_type_code = C_EVENT_TYPE_CODE
192549: FROM (
192550: SELECT xet.event_id event_id
192551: , 0 line_number
192552: , CASE r
192553: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
192554: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
192555:
192556: ELSE null
192557: END object_name
192550: SELECT xet.event_id event_id
192551: , 0 line_number
192552: , CASE r
192553: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
192554: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
192555:
192556: ELSE null
192557: END object_name
192558: , CASE r
192586:
192587: ELSE null
192588: END source_meaning
192589: FROM xla_events_gt xet
192590: , CST_XLA_INV_HEADERS_V h1
192591: , fnd_lookup_values fvl12
192592: , fnd_lookup_values fvl38
192593: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
192594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192871: --
192872: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192873: --
192874:
192875: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192876: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
192877:
192878: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
192879: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
192872: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192873: --
192874:
192875: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192876: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
192877:
192878: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
192879: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
192880: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
192934: , fvl12.meaning source_12_meaning
192935: , h1.TRANSFER_TO_GL_INDICATOR source_38
192936: , fvl38.meaning source_38_meaning
192937: FROM xla_events_gt xet
192938: , CST_XLA_INV_HEADERS_V h1
192939: , fnd_lookup_values fvl12
192940: , fnd_lookup_values fvl38
192941: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192942: and xet.event_type_code = C_EVENT_TYPE_CODE
193959: FROM (
193960: SELECT xet.event_id event_id
193961: , 0 line_number
193962: , CASE r
193963: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
193964: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
193965:
193966: ELSE null
193967: END object_name
193960: SELECT xet.event_id event_id
193961: , 0 line_number
193962: , CASE r
193963: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
193964: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
193965:
193966: ELSE null
193967: END object_name
193968: , CASE r
193996:
193997: ELSE null
193998: END source_meaning
193999: FROM xla_events_gt xet
194000: , CST_XLA_INV_HEADERS_V h1
194001: , fnd_lookup_values fvl12
194002: , fnd_lookup_values fvl38
194003: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
194004: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194281: --
194282: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194283: --
194284:
194285: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194286: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194287:
194288: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194289: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194282: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194283: --
194284:
194285: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194286: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194287:
194288: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194289: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194290: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194344: , fvl12.meaning source_12_meaning
194345: , h1.TRANSFER_TO_GL_INDICATOR source_38
194346: , fvl38.meaning source_38_meaning
194347: FROM xla_events_gt xet
194348: , CST_XLA_INV_HEADERS_V h1
194349: , fnd_lookup_values fvl12
194350: , fnd_lookup_values fvl38
194351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194352: and xet.event_type_code = C_EVENT_TYPE_CODE
195369: FROM (
195370: SELECT xet.event_id event_id
195371: , 0 line_number
195372: , CASE r
195373: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
195374: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
195375:
195376: ELSE null
195377: END object_name
195370: SELECT xet.event_id event_id
195371: , 0 line_number
195372: , CASE r
195373: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
195374: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
195375:
195376: ELSE null
195377: END object_name
195378: , CASE r
195406:
195407: ELSE null
195408: END source_meaning
195409: FROM xla_events_gt xet
195410: , CST_XLA_INV_HEADERS_V h1
195411: , fnd_lookup_values fvl12
195412: , fnd_lookup_values fvl38
195413: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
195414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195691: --
195692: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195693: --
195694:
195695: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195696: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195697:
195698: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195699: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195692: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195693: --
195694:
195695: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195696: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195697:
195698: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195699: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195700: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195754: , fvl12.meaning source_12_meaning
195755: , h1.TRANSFER_TO_GL_INDICATOR source_38
195756: , fvl38.meaning source_38_meaning
195757: FROM xla_events_gt xet
195758: , CST_XLA_INV_HEADERS_V h1
195759: , fnd_lookup_values fvl12
195760: , fnd_lookup_values fvl38
195761: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195762: and xet.event_type_code = C_EVENT_TYPE_CODE
196692: FROM (
196693: SELECT xet.event_id event_id
196694: , 0 line_number
196695: , CASE r
196696: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
196697: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
196698:
196699: ELSE null
196700: END object_name
196693: SELECT xet.event_id event_id
196694: , 0 line_number
196695: , CASE r
196696: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
196697: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
196698:
196699: ELSE null
196700: END object_name
196701: , CASE r
196729:
196730: ELSE null
196731: END source_meaning
196732: FROM xla_events_gt xet
196733: , CST_XLA_INV_HEADERS_V h1
196734: , fnd_lookup_values fvl12
196735: , fnd_lookup_values fvl38
196736: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
196737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197014: --
197015: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197016: --
197017:
197018: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197019: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197020:
197021: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197022: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197015: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197016: --
197017:
197018: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197019: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197020:
197021: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197022: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197023: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197077: , fvl12.meaning source_12_meaning
197078: , h1.TRANSFER_TO_GL_INDICATOR source_38
197079: , fvl38.meaning source_38_meaning
197080: FROM xla_events_gt xet
197081: , CST_XLA_INV_HEADERS_V h1
197082: , fnd_lookup_values fvl12
197083: , fnd_lookup_values fvl38
197084: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197085: and xet.event_type_code = C_EVENT_TYPE_CODE
198015: FROM (
198016: SELECT xet.event_id event_id
198017: , 0 line_number
198018: , CASE r
198019: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
198020: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
198021:
198022: ELSE null
198023: END object_name
198016: SELECT xet.event_id event_id
198017: , 0 line_number
198018: , CASE r
198019: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
198020: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
198021:
198022: ELSE null
198023: END object_name
198024: , CASE r
198052:
198053: ELSE null
198054: END source_meaning
198055: FROM xla_events_gt xet
198056: , CST_XLA_INV_HEADERS_V h1
198057: , fnd_lookup_values fvl12
198058: , fnd_lookup_values fvl38
198059: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
198060: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198337: --
198338: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198339: --
198340:
198341: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198342: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
198343:
198344: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
198345: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
198338: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198339: --
198340:
198341: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198342: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
198343:
198344: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
198345: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
198346: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
198400: , fvl12.meaning source_12_meaning
198401: , h1.TRANSFER_TO_GL_INDICATOR source_38
198402: , fvl38.meaning source_38_meaning
198403: FROM xla_events_gt xet
198404: , CST_XLA_INV_HEADERS_V h1
198405: , fnd_lookup_values fvl12
198406: , fnd_lookup_values fvl38
198407: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198408: and xet.event_type_code = C_EVENT_TYPE_CODE
199280: FROM (
199281: SELECT xet.event_id event_id
199282: , 0 line_number
199283: , CASE r
199284: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
199285: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
199286:
199287: ELSE null
199288: END object_name
199281: SELECT xet.event_id event_id
199282: , 0 line_number
199283: , CASE r
199284: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
199285: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
199286:
199287: ELSE null
199288: END object_name
199289: , CASE r
199317:
199318: ELSE null
199319: END source_meaning
199320: FROM xla_events_gt xet
199321: , CST_XLA_INV_HEADERS_V h1
199322: , fnd_lookup_values fvl12
199323: , fnd_lookup_values fvl38
199324: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
199325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199602: --
199603: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199604: --
199605:
199606: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
199607: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
199608:
199609: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
199610: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
199603: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199604: --
199605:
199606: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
199607: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
199608:
199609: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
199610: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
199611: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199665: , fvl12.meaning source_12_meaning
199666: , h1.TRANSFER_TO_GL_INDICATOR source_38
199667: , fvl38.meaning source_38_meaning
199668: FROM xla_events_gt xet
199669: , CST_XLA_INV_HEADERS_V h1
199670: , fnd_lookup_values fvl12
199671: , fnd_lookup_values fvl38
199672: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199673: and xet.event_type_code = C_EVENT_TYPE_CODE
200516: FROM (
200517: SELECT xet.event_id event_id
200518: , 0 line_number
200519: , CASE r
200520: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
200521: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
200522:
200523: ELSE null
200524: END object_name
200517: SELECT xet.event_id event_id
200518: , 0 line_number
200519: , CASE r
200520: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
200521: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
200522:
200523: ELSE null
200524: END object_name
200525: , CASE r
200553:
200554: ELSE null
200555: END source_meaning
200556: FROM xla_events_gt xet
200557: , CST_XLA_INV_HEADERS_V h1
200558: , fnd_lookup_values fvl12
200559: , fnd_lookup_values fvl38
200560: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
200561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200838: --
200839: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
200840: --
200841:
200842: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
200843: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
200844:
200845: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
200846: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
200839: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
200840: --
200841:
200842: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
200843: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
200844:
200845: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
200846: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
200847: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
200901: , fvl12.meaning source_12_meaning
200902: , h1.TRANSFER_TO_GL_INDICATOR source_38
200903: , fvl38.meaning source_38_meaning
200904: FROM xla_events_gt xet
200905: , CST_XLA_INV_HEADERS_V h1
200906: , fnd_lookup_values fvl12
200907: , fnd_lookup_values fvl38
200908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
200909: and xet.event_type_code = C_EVENT_TYPE_CODE
201752: FROM (
201753: SELECT xet.event_id event_id
201754: , 0 line_number
201755: , CASE r
201756: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
201757: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
201758:
201759: ELSE null
201760: END object_name
201753: SELECT xet.event_id event_id
201754: , 0 line_number
201755: , CASE r
201756: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
201757: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
201758:
201759: ELSE null
201760: END object_name
201761: , CASE r
201789:
201790: ELSE null
201791: END source_meaning
201792: FROM xla_events_gt xet
201793: , CST_XLA_INV_HEADERS_V h1
201794: , fnd_lookup_values fvl12
201795: , fnd_lookup_values fvl38
201796: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
201797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
202074: --
202075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202076: --
202077:
202078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
202079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
202080:
202081: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
202082: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202076: --
202077:
202078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
202079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
202080:
202081: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
202082: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202083: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202137: , fvl12.meaning source_12_meaning
202138: , h1.TRANSFER_TO_GL_INDICATOR source_38
202139: , fvl38.meaning source_38_meaning
202140: FROM xla_events_gt xet
202141: , CST_XLA_INV_HEADERS_V h1
202142: , fnd_lookup_values fvl12
202143: , fnd_lookup_values fvl38
202144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202145: and xet.event_type_code = C_EVENT_TYPE_CODE
206621: FROM (
206622: SELECT xet.event_id event_id
206623: , 0 line_number
206624: , CASE r
206625: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
206626: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
206627:
206628: ELSE null
206629: END object_name
206622: SELECT xet.event_id event_id
206623: , 0 line_number
206624: , CASE r
206625: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
206626: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
206627:
206628: ELSE null
206629: END object_name
206630: , CASE r
206658:
206659: ELSE null
206660: END source_meaning
206661: FROM xla_events_gt xet
206662: , CST_XLA_INV_HEADERS_V h1
206663: , fnd_lookup_values fvl12
206664: , fnd_lookup_values fvl38
206665: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
206666: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206944: --
206945: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
206946: --
206947:
206948: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
206949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
206950:
206951: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
206952: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
206945: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
206946: --
206947:
206948: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
206949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
206950:
206951: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
206952: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
206953: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
207006: , fvl12.meaning source_12_meaning
207007: , h1.TRANSFER_TO_GL_INDICATOR source_38
207008: , fvl38.meaning source_38_meaning
207009: FROM xla_events_gt xet
207010: , CST_XLA_INV_HEADERS_V h1
207011: , fnd_lookup_values fvl12
207012: , fnd_lookup_values fvl38
207013: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
207014: and xet.event_class_code = C_EVENT_CLASS_CODE