140751: FROM (
140752: SELECT xet.event_id event_id
140753: , 0 line_number
140754: , CASE r
140755: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
140756: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
140757:
140758: ELSE null
140759: END object_name
140752: SELECT xet.event_id event_id
140753: , 0 line_number
140754: , CASE r
140755: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
140756: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
140757:
140758: ELSE null
140759: END object_name
140760: , CASE r
140788:
140789: ELSE null
140790: END source_meaning
140791: FROM xla_events_gt xet
140792: , CST_XLA_INV_HEADERS_V h1
140793: , fnd_lookup_values fvl12
140794: , fnd_lookup_values fvl38
140795: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
140796: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141074: --
141075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
141076: --
141077:
141078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
141079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
141080:
141081: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
141082: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
141075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
141076: --
141077:
141078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
141079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
141080:
141081: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
141082: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
141083: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
141136: , fvl12.meaning source_12_meaning
141137: , h1.TRANSFER_TO_GL_INDICATOR source_38
141138: , fvl38.meaning source_38_meaning
141139: FROM xla_events_gt xet
141140: , CST_XLA_INV_HEADERS_V h1
141141: , fnd_lookup_values fvl12
141142: , fnd_lookup_values fvl38
141143: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
141144: and xet.event_class_code = C_EVENT_CLASS_CODE
143389: , CASE r
143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'
143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'
143399: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
143400: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
143401: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
143402:
143403: ELSE null
143404: END object_name
143405: , CASE r
143473:
143474: ELSE null
143475: END source_meaning
143476: FROM xla_events_gt xet
143477: , CST_XLA_INV_HEADERS_V h1
143478: , CST_XLA_INV_REF_V h3
143479: , PO_REQ_DISTS_REF_V h4
143480: , PO_REQ_HEADERS_REF_V h5
143481: , PSA_CST_XLA_UPG_V h6
143766:
143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143775: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
143776: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
143777: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
143778: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143779:
143780: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143781: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143782: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143855: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
143856: , h1.TRANSFER_TO_GL_INDICATOR source_38
143857: , fvl38.meaning source_38_meaning
143858: FROM xla_events_gt xet
143859: , CST_XLA_INV_HEADERS_V h1
143860: , CST_XLA_INV_REF_V h3
143861: , PO_REQ_DISTS_REF_V h4
143862: , PO_REQ_HEADERS_REF_V h5
143863: , PSA_CST_XLA_UPG_V h6
144996: FROM (
144997: SELECT xet.event_id event_id
144998: , 0 line_number
144999: , CASE r
145000: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
145001: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
145002:
145003: ELSE null
145004: END object_name
144997: SELECT xet.event_id event_id
144998: , 0 line_number
144999: , CASE r
145000: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
145001: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
145002:
145003: ELSE null
145004: END object_name
145005: , CASE r
145033:
145034: ELSE null
145035: END source_meaning
145036: FROM xla_events_gt xet
145037: , CST_XLA_INV_HEADERS_V h1
145038: , fnd_lookup_values fvl12
145039: , fnd_lookup_values fvl38
145040: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145319: --
145320: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
145321: --
145322:
145323: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
145324: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
145325:
145326: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
145327: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
145320: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
145321: --
145322:
145323: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
145324: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
145325:
145326: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
145327: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
145328: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
145381: , fvl12.meaning source_12_meaning
145382: , h1.TRANSFER_TO_GL_INDICATOR source_38
145383: , fvl38.meaning source_38_meaning
145384: FROM xla_events_gt xet
145385: , CST_XLA_INV_HEADERS_V h1
145386: , fnd_lookup_values fvl12
145387: , fnd_lookup_values fvl38
145388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
145389: and xet.event_class_code = C_EVENT_CLASS_CODE
146409: , CASE r
146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'
146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'
146419: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
146420: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
146421: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
146422:
146423: ELSE null
146424: END object_name
146425: , CASE r
146493:
146494: ELSE null
146495: END source_meaning
146496: FROM xla_events_gt xet
146497: , CST_XLA_INV_HEADERS_V h1
146498: , CST_XLA_INV_REF_V h3
146499: , PO_REQ_DISTS_REF_V h4
146500: , PO_REQ_HEADERS_REF_V h5
146501: , PSA_CST_XLA_UPG_V h6
146786:
146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146795: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
146796: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
146797: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
146798: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
146799:
146800: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
146801: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
146802: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
146875: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
146876: , h1.TRANSFER_TO_GL_INDICATOR source_38
146877: , fvl38.meaning source_38_meaning
146878: FROM xla_events_gt xet
146879: , CST_XLA_INV_HEADERS_V h1
146880: , CST_XLA_INV_REF_V h3
146881: , PO_REQ_DISTS_REF_V h4
146882: , PO_REQ_HEADERS_REF_V h5
146883: , PSA_CST_XLA_UPG_V h6
147977: FROM (
147978: SELECT xet.event_id event_id
147979: , 0 line_number
147980: , CASE r
147981: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
147982: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
147983:
147984: ELSE null
147985: END object_name
147978: SELECT xet.event_id event_id
147979: , 0 line_number
147980: , CASE r
147981: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
147982: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
147983:
147984: ELSE null
147985: END object_name
147986: , CASE r
148014:
148015: ELSE null
148016: END source_meaning
148017: FROM xla_events_gt xet
148018: , CST_XLA_INV_HEADERS_V h1
148019: , fnd_lookup_values fvl12
148020: , fnd_lookup_values fvl38
148021: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
148022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148300: --
148301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148302: --
148303:
148304: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148305: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
148306:
148307: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
148308: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
148301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148302: --
148303:
148304: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148305: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
148306:
148307: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
148308: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
148309: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
148362: , fvl12.meaning source_12_meaning
148363: , h1.TRANSFER_TO_GL_INDICATOR source_38
148364: , fvl38.meaning source_38_meaning
148365: FROM xla_events_gt xet
148366: , CST_XLA_INV_HEADERS_V h1
148367: , fnd_lookup_values fvl12
148368: , fnd_lookup_values fvl38
148369: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148370: and xet.event_class_code = C_EVENT_CLASS_CODE
149329: FROM (
149330: SELECT xet.event_id event_id
149331: , 0 line_number
149332: , CASE r
149333: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
149334: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
149335:
149336: ELSE null
149337: END object_name
149330: SELECT xet.event_id event_id
149331: , 0 line_number
149332: , CASE r
149333: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
149334: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
149335:
149336: ELSE null
149337: END object_name
149338: , CASE r
149366:
149367: ELSE null
149368: END source_meaning
149369: FROM xla_events_gt xet
149370: , CST_XLA_INV_HEADERS_V h1
149371: , fnd_lookup_values fvl12
149372: , fnd_lookup_values fvl38
149373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
149374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149652: --
149653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
149654: --
149655:
149656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
149657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
149658:
149659: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
149660: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
149653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
149654: --
149655:
149656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
149657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
149658:
149659: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
149660: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
149661: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
149714: , fvl12.meaning source_12_meaning
149715: , h1.TRANSFER_TO_GL_INDICATOR source_38
149716: , fvl38.meaning source_38_meaning
149717: FROM xla_events_gt xet
149718: , CST_XLA_INV_HEADERS_V h1
149719: , fnd_lookup_values fvl12
149720: , fnd_lookup_values fvl38
149721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
149722: and xet.event_class_code = C_EVENT_CLASS_CODE
150568: , CASE r
150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'
150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'
150578: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
150579: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
150580: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
150581:
150582: ELSE null
150583: END object_name
150584: , CASE r
150652:
150653: ELSE null
150654: END source_meaning
150655: FROM xla_events_gt xet
150656: , CST_XLA_INV_HEADERS_V h1
150657: , CST_XLA_INV_REF_V h3
150658: , PO_REQ_DISTS_REF_V h4
150659: , PO_REQ_HEADERS_REF_V h5
150660: , PSA_CST_XLA_UPG_V h6
150945:
150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150954: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
150955: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
150956: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
150957: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
150958:
150959: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
150960: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
150961: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151034: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
151035: , h1.TRANSFER_TO_GL_INDICATOR source_38
151036: , fvl38.meaning source_38_meaning
151037: FROM xla_events_gt xet
151038: , CST_XLA_INV_HEADERS_V h1
151039: , CST_XLA_INV_REF_V h3
151040: , PO_REQ_DISTS_REF_V h4
151041: , PO_REQ_HEADERS_REF_V h5
151042: , PSA_CST_XLA_UPG_V h6
151941: FROM (
151942: SELECT xet.event_id event_id
151943: , 0 line_number
151944: , CASE r
151945: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
151946: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
151947:
151948: ELSE null
151949: END object_name
151942: SELECT xet.event_id event_id
151943: , 0 line_number
151944: , CASE r
151945: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
151946: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
151947:
151948: ELSE null
151949: END object_name
151950: , CASE r
151978:
151979: ELSE null
151980: END source_meaning
151981: FROM xla_events_gt xet
151982: , CST_XLA_INV_HEADERS_V h1
151983: , fnd_lookup_values fvl12
151984: , fnd_lookup_values fvl38
151985: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
151986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152264: --
152265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
152266: --
152267:
152268: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
152269: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
152270:
152271: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
152272: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
152265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
152266: --
152267:
152268: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
152269: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
152270:
152271: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
152272: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
152273: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
152326: , fvl12.meaning source_12_meaning
152327: , h1.TRANSFER_TO_GL_INDICATOR source_38
152328: , fvl38.meaning source_38_meaning
152329: FROM xla_events_gt xet
152330: , CST_XLA_INV_HEADERS_V h1
152331: , fnd_lookup_values fvl12
152332: , fnd_lookup_values fvl38
152333: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
152334: and xet.event_class_code = C_EVENT_CLASS_CODE
153351: FROM (
153352: SELECT xet.event_id event_id
153353: , 0 line_number
153354: , CASE r
153355: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
153356: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
153357:
153358: ELSE null
153359: END object_name
153352: SELECT xet.event_id event_id
153353: , 0 line_number
153354: , CASE r
153355: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
153356: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
153357:
153358: ELSE null
153359: END object_name
153360: , CASE r
153388:
153389: ELSE null
153390: END source_meaning
153391: FROM xla_events_gt xet
153392: , CST_XLA_INV_HEADERS_V h1
153393: , fnd_lookup_values fvl12
153394: , fnd_lookup_values fvl38
153395: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153674: --
153675: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153676: --
153677:
153678: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153679: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
153680:
153681: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
153682: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153675: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153676: --
153677:
153678: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153679: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
153680:
153681: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
153682: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153683: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153736: , fvl12.meaning source_12_meaning
153737: , h1.TRANSFER_TO_GL_INDICATOR source_38
153738: , fvl38.meaning source_38_meaning
153739: FROM xla_events_gt xet
153740: , CST_XLA_INV_HEADERS_V h1
153741: , fnd_lookup_values fvl12
153742: , fnd_lookup_values fvl38
153743: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153744: and xet.event_class_code = C_EVENT_CLASS_CODE
154674: FROM (
154675: SELECT xet.event_id event_id
154676: , 0 line_number
154677: , CASE r
154678: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
154679: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
154680:
154681: ELSE null
154682: END object_name
154675: SELECT xet.event_id event_id
154676: , 0 line_number
154677: , CASE r
154678: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
154679: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
154680:
154681: ELSE null
154682: END object_name
154683: , CASE r
154711:
154712: ELSE null
154713: END source_meaning
154714: FROM xla_events_gt xet
154715: , CST_XLA_INV_HEADERS_V h1
154716: , fnd_lookup_values fvl12
154717: , fnd_lookup_values fvl38
154718: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154997: --
154998: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154999: --
155000:
155001: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155002: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
155003:
155004: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
155005: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
154998: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154999: --
155000:
155001: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155002: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
155003:
155004: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
155005: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
155006: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
155059: , fvl12.meaning source_12_meaning
155060: , h1.TRANSFER_TO_GL_INDICATOR source_38
155061: , fvl38.meaning source_38_meaning
155062: FROM xla_events_gt xet
155063: , CST_XLA_INV_HEADERS_V h1
155064: , fnd_lookup_values fvl12
155065: , fnd_lookup_values fvl38
155066: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
155067: and xet.event_class_code = C_EVENT_CLASS_CODE
155910: FROM (
155911: SELECT xet.event_id event_id
155912: , 0 line_number
155913: , CASE r
155914: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
155915: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
155916:
155917: ELSE null
155918: END object_name
155911: SELECT xet.event_id event_id
155912: , 0 line_number
155913: , CASE r
155914: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
155915: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
155916:
155917: ELSE null
155918: END object_name
155919: , CASE r
155947:
155948: ELSE null
155949: END source_meaning
155950: FROM xla_events_gt xet
155951: , CST_XLA_INV_HEADERS_V h1
155952: , fnd_lookup_values fvl12
155953: , fnd_lookup_values fvl38
155954: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156233: --
156234: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156235: --
156236:
156237: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
156238: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
156239:
156240: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
156241: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156234: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156235: --
156236:
156237: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
156238: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
156239:
156240: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
156241: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156242: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156295: , fvl12.meaning source_12_meaning
156296: , h1.TRANSFER_TO_GL_INDICATOR source_38
156297: , fvl38.meaning source_38_meaning
156298: FROM xla_events_gt xet
156299: , CST_XLA_INV_HEADERS_V h1
156300: , fnd_lookup_values fvl12
156301: , fnd_lookup_values fvl38
156302: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156303: and xet.event_class_code = C_EVENT_CLASS_CODE
159678: FROM (
159679: SELECT xet.event_id event_id
159680: , 0 line_number
159681: , CASE r
159682: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
159683: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
159684: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
159685:
159686: ELSE null
159679: SELECT xet.event_id event_id
159680: , 0 line_number
159681: , CASE r
159682: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
159683: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
159684: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
159685:
159686: ELSE null
159687: END object_name
159680: , 0 line_number
159681: , CASE r
159682: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
159683: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
159684: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
159685:
159686: ELSE null
159687: END object_name
159688: , CASE r
159721:
159722: ELSE null
159723: END source_meaning
159724: FROM xla_events_gt xet
159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38
159729: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
160012: --
160013: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160014: --
160015:
160016: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
160017: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
160018: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
160019:
160020: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
160013: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160014: --
160015:
160016: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
160017: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
160018: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
160019:
160020: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
160021: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160014: --
160015:
160016: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
160017: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
160018: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
160019:
160020: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
160021: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160022: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160079: , fvl35.meaning source_35_meaning
160080: , h1.TRANSFER_TO_GL_INDICATOR source_38
160081: , fvl38.meaning source_38_meaning
160082: FROM xla_events_gt xet
160083: , CST_XLA_INV_HEADERS_V h1
160084: , fnd_lookup_values fvl12
160085: , fnd_lookup_values fvl35
160086: , fnd_lookup_values fvl38
160087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161001: FROM (
161002: SELECT xet.event_id event_id
161003: , 0 line_number
161004: , CASE r
161005: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
161006: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
161007:
161008: ELSE null
161009: END object_name
161002: SELECT xet.event_id event_id
161003: , 0 line_number
161004: , CASE r
161005: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
161006: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
161007:
161008: ELSE null
161009: END object_name
161010: , CASE r
161038:
161039: ELSE null
161040: END source_meaning
161041: FROM xla_events_gt xet
161042: , CST_XLA_INV_HEADERS_V h1
161043: , fnd_lookup_values fvl12
161044: , fnd_lookup_values fvl38
161045: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
161046: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161324: --
161325: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161326: --
161327:
161328: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161329: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
161330:
161331: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
161332: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
161325: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161326: --
161327:
161328: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161329: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
161330:
161331: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
161332: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
161333: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
161386: , fvl12.meaning source_12_meaning
161387: , h1.TRANSFER_TO_GL_INDICATOR source_38
161388: , fvl38.meaning source_38_meaning
161389: FROM xla_events_gt xet
161390: , CST_XLA_INV_HEADERS_V h1
161391: , fnd_lookup_values fvl12
161392: , fnd_lookup_values fvl38
161393: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161394: and xet.event_class_code = C_EVENT_CLASS_CODE
164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'
164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'
164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'
164950: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
164951:
164952: ELSE null
164953: END object_name
164954: , CASE r
165022:
165023: ELSE null
165024: END source_meaning
165025: FROM xla_events_gt xet
165026: , CST_XLA_INV_HEADERS_V h1
165027: , CST_XLA_INV_REF_V h3
165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165325: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
165326: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
165327: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165328:
165329: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
165330: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
165331: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165404: , h3.TXN_PO_DISTRIBUTION_ID source_28
165405: , h1.TRANSFER_TO_GL_INDICATOR source_38
165406: , fvl38.meaning source_38_meaning
165407: FROM xla_events_gt xet
165408: , CST_XLA_INV_HEADERS_V h1
165409: , CST_XLA_INV_REF_V h3
165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5
165412: , PSA_CST_XLA_UPG_V h6
170329: FROM (
170330: SELECT xet.event_id event_id
170331: , 0 line_number
170332: , CASE r
170333: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
170334: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
170335:
170336: ELSE null
170337: END object_name
170330: SELECT xet.event_id event_id
170331: , 0 line_number
170332: , CASE r
170333: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
170334: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
170335:
170336: ELSE null
170337: END object_name
170338: , CASE r
170366:
170367: ELSE null
170368: END source_meaning
170369: FROM xla_events_gt xet
170370: , CST_XLA_INV_HEADERS_V h1
170371: , fnd_lookup_values fvl12
170372: , fnd_lookup_values fvl38
170373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
170374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170652: --
170653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170654: --
170655:
170656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170658:
170659: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170660: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170654: --
170655:
170656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170658:
170659: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170660: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170661: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170714: , fvl12.meaning source_12_meaning
170715: , h1.TRANSFER_TO_GL_INDICATOR source_38
170716: , fvl38.meaning source_38_meaning
170717: FROM xla_events_gt xet
170718: , CST_XLA_INV_HEADERS_V h1
170719: , fnd_lookup_values fvl12
170720: , fnd_lookup_values fvl38
170721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170722: and xet.event_class_code = C_EVENT_CLASS_CODE
171623: FROM (
171624: SELECT xet.event_id event_id
171625: , 0 line_number
171626: , CASE r
171627: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
171628: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
171629:
171630: ELSE null
171631: END object_name
171624: SELECT xet.event_id event_id
171625: , 0 line_number
171626: , CASE r
171627: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
171628: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
171629:
171630: ELSE null
171631: END object_name
171632: , CASE r
171660:
171661: ELSE null
171662: END source_meaning
171663: FROM xla_events_gt xet
171664: , CST_XLA_INV_HEADERS_V h1
171665: , fnd_lookup_values fvl12
171666: , fnd_lookup_values fvl38
171667: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
171668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171945: --
171946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171947: --
171948:
171949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171950: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171951:
171952: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171953: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171947: --
171948:
171949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171950: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171951:
171952: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171953: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171954: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
172008: , fvl12.meaning source_12_meaning
172009: , h1.TRANSFER_TO_GL_INDICATOR source_38
172010: , fvl38.meaning source_38_meaning
172011: FROM xla_events_gt xet
172012: , CST_XLA_INV_HEADERS_V h1
172013: , fnd_lookup_values fvl12
172014: , fnd_lookup_values fvl38
172015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172016: and xet.event_type_code = C_EVENT_TYPE_CODE
172917: FROM (
172918: SELECT xet.event_id event_id
172919: , 0 line_number
172920: , CASE r
172921: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
172922: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
172923:
172924: ELSE null
172925: END object_name
172918: SELECT xet.event_id event_id
172919: , 0 line_number
172920: , CASE r
172921: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
172922: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
172923:
172924: ELSE null
172925: END object_name
172926: , CASE r
172954:
172955: ELSE null
172956: END source_meaning
172957: FROM xla_events_gt xet
172958: , CST_XLA_INV_HEADERS_V h1
172959: , fnd_lookup_values fvl12
172960: , fnd_lookup_values fvl38
172961: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
172962: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
173239: --
173240: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
173241: --
173242:
173243: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
173244: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
173245:
173246: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
173247: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
173240: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
173241: --
173242:
173243: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
173244: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
173245:
173246: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
173247: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
173248: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
173302: , fvl12.meaning source_12_meaning
173303: , h1.TRANSFER_TO_GL_INDICATOR source_38
173304: , fvl38.meaning source_38_meaning
173305: FROM xla_events_gt xet
173306: , CST_XLA_INV_HEADERS_V h1
173307: , fnd_lookup_values fvl12
173308: , fnd_lookup_values fvl38
173309: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
173310: and xet.event_type_code = C_EVENT_TYPE_CODE
174153: FROM (
174154: SELECT xet.event_id event_id
174155: , 0 line_number
174156: , CASE r
174157: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
174158: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
174159:
174160: ELSE null
174161: END object_name
174154: SELECT xet.event_id event_id
174155: , 0 line_number
174156: , CASE r
174157: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
174158: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
174159:
174160: ELSE null
174161: END object_name
174162: , CASE r
174190:
174191: ELSE null
174192: END source_meaning
174193: FROM xla_events_gt xet
174194: , CST_XLA_INV_HEADERS_V h1
174195: , fnd_lookup_values fvl12
174196: , fnd_lookup_values fvl38
174197: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
174198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174475: --
174476: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174477: --
174478:
174479: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174480: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174481:
174482: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174483: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174476: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174477: --
174478:
174479: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174480: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174481:
174482: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174483: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174484: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174538: , fvl12.meaning source_12_meaning
174539: , h1.TRANSFER_TO_GL_INDICATOR source_38
174540: , fvl38.meaning source_38_meaning
174541: FROM xla_events_gt xet
174542: , CST_XLA_INV_HEADERS_V h1
174543: , fnd_lookup_values fvl12
174544: , fnd_lookup_values fvl38
174545: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174546: and xet.event_type_code = C_EVENT_TYPE_CODE
175563: FROM (
175564: SELECT xet.event_id event_id
175565: , 0 line_number
175566: , CASE r
175567: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
175568: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
175569:
175570: ELSE null
175571: END object_name
175564: SELECT xet.event_id event_id
175565: , 0 line_number
175566: , CASE r
175567: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
175568: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
175569:
175570: ELSE null
175571: END object_name
175572: , CASE r
175600:
175601: ELSE null
175602: END source_meaning
175603: FROM xla_events_gt xet
175604: , CST_XLA_INV_HEADERS_V h1
175605: , fnd_lookup_values fvl12
175606: , fnd_lookup_values fvl38
175607: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175885: --
175886: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175887: --
175888:
175889: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175890: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
175891:
175892: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
175893: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
175886: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175887: --
175888:
175889: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175890: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
175891:
175892: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
175893: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
175894: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
175948: , fvl12.meaning source_12_meaning
175949: , h1.TRANSFER_TO_GL_INDICATOR source_38
175950: , fvl38.meaning source_38_meaning
175951: FROM xla_events_gt xet
175952: , CST_XLA_INV_HEADERS_V h1
175953: , fnd_lookup_values fvl12
175954: , fnd_lookup_values fvl38
175955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175956: and xet.event_type_code = C_EVENT_TYPE_CODE
176973: FROM (
176974: SELECT xet.event_id event_id
176975: , 0 line_number
176976: , CASE r
176977: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
176978: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
176979:
176980: ELSE null
176981: END object_name
176974: SELECT xet.event_id event_id
176975: , 0 line_number
176976: , CASE r
176977: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
176978: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
176979:
176980: ELSE null
176981: END object_name
176982: , CASE r
177010:
177011: ELSE null
177012: END source_meaning
177013: FROM xla_events_gt xet
177014: , CST_XLA_INV_HEADERS_V h1
177015: , fnd_lookup_values fvl12
177016: , fnd_lookup_values fvl38
177017: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
177018: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177295: --
177296: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177297: --
177298:
177299: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
177300: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
177301:
177302: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
177303: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
177296: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177297: --
177298:
177299: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
177300: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
177301:
177302: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
177303: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
177304: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177358: , fvl12.meaning source_12_meaning
177359: , h1.TRANSFER_TO_GL_INDICATOR source_38
177360: , fvl38.meaning source_38_meaning
177361: FROM xla_events_gt xet
177362: , CST_XLA_INV_HEADERS_V h1
177363: , fnd_lookup_values fvl12
177364: , fnd_lookup_values fvl38
177365: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177366: and xet.event_type_code = C_EVENT_TYPE_CODE
178383: FROM (
178384: SELECT xet.event_id event_id
178385: , 0 line_number
178386: , CASE r
178387: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
178388: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
178389:
178390: ELSE null
178391: END object_name
178384: SELECT xet.event_id event_id
178385: , 0 line_number
178386: , CASE r
178387: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
178388: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
178389:
178390: ELSE null
178391: END object_name
178392: , CASE r
178420:
178421: ELSE null
178422: END source_meaning
178423: FROM xla_events_gt xet
178424: , CST_XLA_INV_HEADERS_V h1
178425: , fnd_lookup_values fvl12
178426: , fnd_lookup_values fvl38
178427: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
178428: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178705: --
178706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178707: --
178708:
178709: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178710: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178711:
178712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178713: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178707: --
178708:
178709: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178710: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178711:
178712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178713: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178714: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178768: , fvl12.meaning source_12_meaning
178769: , h1.TRANSFER_TO_GL_INDICATOR source_38
178770: , fvl38.meaning source_38_meaning
178771: FROM xla_events_gt xet
178772: , CST_XLA_INV_HEADERS_V h1
178773: , fnd_lookup_values fvl12
178774: , fnd_lookup_values fvl38
178775: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178776: and xet.event_type_code = C_EVENT_TYPE_CODE
179793: FROM (
179794: SELECT xet.event_id event_id
179795: , 0 line_number
179796: , CASE r
179797: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
179798: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
179799:
179800: ELSE null
179801: END object_name
179794: SELECT xet.event_id event_id
179795: , 0 line_number
179796: , CASE r
179797: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
179798: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
179799:
179800: ELSE null
179801: END object_name
179802: , CASE r
179830:
179831: ELSE null
179832: END source_meaning
179833: FROM xla_events_gt xet
179834: , CST_XLA_INV_HEADERS_V h1
179835: , fnd_lookup_values fvl12
179836: , fnd_lookup_values fvl38
179837: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180115: --
180116: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180117: --
180118:
180119: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180120: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
180121:
180122: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
180123: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
180116: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180117: --
180118:
180119: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180120: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
180121:
180122: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
180123: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
180124: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
180178: , fvl12.meaning source_12_meaning
180179: , h1.TRANSFER_TO_GL_INDICATOR source_38
180180: , fvl38.meaning source_38_meaning
180181: FROM xla_events_gt xet
180182: , CST_XLA_INV_HEADERS_V h1
180183: , fnd_lookup_values fvl12
180184: , fnd_lookup_values fvl38
180185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180186: and xet.event_type_code = C_EVENT_TYPE_CODE
181203: FROM (
181204: SELECT xet.event_id event_id
181205: , 0 line_number
181206: , CASE r
181207: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
181208: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
181209:
181210: ELSE null
181211: END object_name
181204: SELECT xet.event_id event_id
181205: , 0 line_number
181206: , CASE r
181207: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
181208: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
181209:
181210: ELSE null
181211: END object_name
181212: , CASE r
181240:
181241: ELSE null
181242: END source_meaning
181243: FROM xla_events_gt xet
181244: , CST_XLA_INV_HEADERS_V h1
181245: , fnd_lookup_values fvl12
181246: , fnd_lookup_values fvl38
181247: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181248: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181525: --
181526: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181527: --
181528:
181529: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181530: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
181531:
181532: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
181533: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
181526: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181527: --
181528:
181529: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181530: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
181531:
181532: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
181533: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
181534: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
181588: , fvl12.meaning source_12_meaning
181589: , h1.TRANSFER_TO_GL_INDICATOR source_38
181590: , fvl38.meaning source_38_meaning
181591: FROM xla_events_gt xet
181592: , CST_XLA_INV_HEADERS_V h1
181593: , fnd_lookup_values fvl12
181594: , fnd_lookup_values fvl38
181595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
181596: and xet.event_type_code = C_EVENT_TYPE_CODE
182613: FROM (
182614: SELECT xet.event_id event_id
182615: , 0 line_number
182616: , CASE r
182617: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
182618: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
182619:
182620: ELSE null
182621: END object_name
182614: SELECT xet.event_id event_id
182615: , 0 line_number
182616: , CASE r
182617: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
182618: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
182619:
182620: ELSE null
182621: END object_name
182622: , CASE r
182650:
182651: ELSE null
182652: END source_meaning
182653: FROM xla_events_gt xet
182654: , CST_XLA_INV_HEADERS_V h1
182655: , fnd_lookup_values fvl12
182656: , fnd_lookup_values fvl38
182657: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182935: --
182936: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
182937: --
182938:
182939: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
182940: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
182941:
182942: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
182943: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
182936: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
182937: --
182938:
182939: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
182940: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
182941:
182942: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
182943: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
182944: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
182998: , fvl12.meaning source_12_meaning
182999: , h1.TRANSFER_TO_GL_INDICATOR source_38
183000: , fvl38.meaning source_38_meaning
183001: FROM xla_events_gt xet
183002: , CST_XLA_INV_HEADERS_V h1
183003: , fnd_lookup_values fvl12
183004: , fnd_lookup_values fvl38
183005: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183006: and xet.event_type_code = C_EVENT_TYPE_CODE
183849: FROM (
183850: SELECT xet.event_id event_id
183851: , 0 line_number
183852: , CASE r
183853: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
183854: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
183855:
183856: ELSE null
183857: END object_name
183850: SELECT xet.event_id event_id
183851: , 0 line_number
183852: , CASE r
183853: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
183854: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
183855:
183856: ELSE null
183857: END object_name
183858: , CASE r
183886:
183887: ELSE null
183888: END source_meaning
183889: FROM xla_events_gt xet
183890: , CST_XLA_INV_HEADERS_V h1
183891: , fnd_lookup_values fvl12
183892: , fnd_lookup_values fvl38
183893: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
183894: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184171: --
184172: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184173: --
184174:
184175: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184176: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
184177:
184178: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
184179: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
184172: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184173: --
184174:
184175: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184176: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
184177:
184178: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
184179: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
184180: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
184234: , fvl12.meaning source_12_meaning
184235: , h1.TRANSFER_TO_GL_INDICATOR source_38
184236: , fvl38.meaning source_38_meaning
184237: FROM xla_events_gt xet
184238: , CST_XLA_INV_HEADERS_V h1
184239: , fnd_lookup_values fvl12
184240: , fnd_lookup_values fvl38
184241: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184242: and xet.event_type_code = C_EVENT_TYPE_CODE
185259: FROM (
185260: SELECT xet.event_id event_id
185261: , 0 line_number
185262: , CASE r
185263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
185264: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
185265:
185266: ELSE null
185267: END object_name
185260: SELECT xet.event_id event_id
185261: , 0 line_number
185262: , CASE r
185263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
185264: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
185265:
185266: ELSE null
185267: END object_name
185268: , CASE r
185296:
185297: ELSE null
185298: END source_meaning
185299: FROM xla_events_gt xet
185300: , CST_XLA_INV_HEADERS_V h1
185301: , fnd_lookup_values fvl12
185302: , fnd_lookup_values fvl38
185303: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185304: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185581: --
185582: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185583: --
185584:
185585: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
185586: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
185587:
185588: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
185589: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
185582: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185583: --
185584:
185585: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
185586: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
185587:
185588: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
185589: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
185590: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
185644: , fvl12.meaning source_12_meaning
185645: , h1.TRANSFER_TO_GL_INDICATOR source_38
185646: , fvl38.meaning source_38_meaning
185647: FROM xla_events_gt xet
185648: , CST_XLA_INV_HEADERS_V h1
185649: , fnd_lookup_values fvl12
185650: , fnd_lookup_values fvl38
185651: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
185652: and xet.event_type_code = C_EVENT_TYPE_CODE
186669: FROM (
186670: SELECT xet.event_id event_id
186671: , 0 line_number
186672: , CASE r
186673: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
186674: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
186675:
186676: ELSE null
186677: END object_name
186670: SELECT xet.event_id event_id
186671: , 0 line_number
186672: , CASE r
186673: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
186674: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
186675:
186676: ELSE null
186677: END object_name
186678: , CASE r
186706:
186707: ELSE null
186708: END source_meaning
186709: FROM xla_events_gt xet
186710: , CST_XLA_INV_HEADERS_V h1
186711: , fnd_lookup_values fvl12
186712: , fnd_lookup_values fvl38
186713: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
186714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186991: --
186992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
186993: --
186994:
186995: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186996: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
186997:
186998: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
186999: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
186992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
186993: --
186994:
186995: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186996: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
186997:
186998: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
186999: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187000: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187054: , fvl12.meaning source_12_meaning
187055: , h1.TRANSFER_TO_GL_INDICATOR source_38
187056: , fvl38.meaning source_38_meaning
187057: FROM xla_events_gt xet
187058: , CST_XLA_INV_HEADERS_V h1
187059: , fnd_lookup_values fvl12
187060: , fnd_lookup_values fvl38
187061: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187062: and xet.event_type_code = C_EVENT_TYPE_CODE
187992: FROM (
187993: SELECT xet.event_id event_id
187994: , 0 line_number
187995: , CASE r
187996: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
187997: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
187998:
187999: ELSE null
188000: END object_name
187993: SELECT xet.event_id event_id
187994: , 0 line_number
187995: , CASE r
187996: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
187997: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
187998:
187999: ELSE null
188000: END object_name
188001: , CASE r
188029:
188030: ELSE null
188031: END source_meaning
188032: FROM xla_events_gt xet
188033: , CST_XLA_INV_HEADERS_V h1
188034: , fnd_lookup_values fvl12
188035: , fnd_lookup_values fvl38
188036: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188037: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188314: --
188315: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188316: --
188317:
188318: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188319: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
188320:
188321: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
188322: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
188315: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188316: --
188317:
188318: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188319: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
188320:
188321: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
188322: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
188323: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
188377: , fvl12.meaning source_12_meaning
188378: , h1.TRANSFER_TO_GL_INDICATOR source_38
188379: , fvl38.meaning source_38_meaning
188380: FROM xla_events_gt xet
188381: , CST_XLA_INV_HEADERS_V h1
188382: , fnd_lookup_values fvl12
188383: , fnd_lookup_values fvl38
188384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188385: and xet.event_type_code = C_EVENT_TYPE_CODE
189315: FROM (
189316: SELECT xet.event_id event_id
189317: , 0 line_number
189318: , CASE r
189319: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
189320: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
189321:
189322: ELSE null
189323: END object_name
189316: SELECT xet.event_id event_id
189317: , 0 line_number
189318: , CASE r
189319: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
189320: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
189321:
189322: ELSE null
189323: END object_name
189324: , CASE r
189352:
189353: ELSE null
189354: END source_meaning
189355: FROM xla_events_gt xet
189356: , CST_XLA_INV_HEADERS_V h1
189357: , fnd_lookup_values fvl12
189358: , fnd_lookup_values fvl38
189359: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189360: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189637: --
189638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
189639: --
189640:
189641: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
189642: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
189643:
189644: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
189645: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
189638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
189639: --
189640:
189641: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
189642: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
189643:
189644: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
189645: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
189646: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
189700: , fvl12.meaning source_12_meaning
189701: , h1.TRANSFER_TO_GL_INDICATOR source_38
189702: , fvl38.meaning source_38_meaning
189703: FROM xla_events_gt xet
189704: , CST_XLA_INV_HEADERS_V h1
189705: , fnd_lookup_values fvl12
189706: , fnd_lookup_values fvl38
189707: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
189708: and xet.event_type_code = C_EVENT_TYPE_CODE
190580: FROM (
190581: SELECT xet.event_id event_id
190582: , 0 line_number
190583: , CASE r
190584: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
190585: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
190586:
190587: ELSE null
190588: END object_name
190581: SELECT xet.event_id event_id
190582: , 0 line_number
190583: , CASE r
190584: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
190585: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
190586:
190587: ELSE null
190588: END object_name
190589: , CASE r
190617:
190618: ELSE null
190619: END source_meaning
190620: FROM xla_events_gt xet
190621: , CST_XLA_INV_HEADERS_V h1
190622: , fnd_lookup_values fvl12
190623: , fnd_lookup_values fvl38
190624: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
190625: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190902: --
190903: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190904: --
190905:
190906: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190907: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
190908:
190909: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
190910: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
190903: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190904: --
190905:
190906: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190907: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
190908:
190909: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
190910: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
190911: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
190965: , fvl12.meaning source_12_meaning
190966: , h1.TRANSFER_TO_GL_INDICATOR source_38
190967: , fvl38.meaning source_38_meaning
190968: FROM xla_events_gt xet
190969: , CST_XLA_INV_HEADERS_V h1
190970: , fnd_lookup_values fvl12
190971: , fnd_lookup_values fvl38
190972: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190973: and xet.event_type_code = C_EVENT_TYPE_CODE
191816: FROM (
191817: SELECT xet.event_id event_id
191818: , 0 line_number
191819: , CASE r
191820: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
191821: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
191822:
191823: ELSE null
191824: END object_name
191817: SELECT xet.event_id event_id
191818: , 0 line_number
191819: , CASE r
191820: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
191821: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
191822:
191823: ELSE null
191824: END object_name
191825: , CASE r
191853:
191854: ELSE null
191855: END source_meaning
191856: FROM xla_events_gt xet
191857: , CST_XLA_INV_HEADERS_V h1
191858: , fnd_lookup_values fvl12
191859: , fnd_lookup_values fvl38
191860: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192138: --
192139: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192140: --
192141:
192142: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192143: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
192144:
192145: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
192146: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
192139: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192140: --
192141:
192142: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192143: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
192144:
192145: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
192146: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
192147: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
192201: , fvl12.meaning source_12_meaning
192202: , h1.TRANSFER_TO_GL_INDICATOR source_38
192203: , fvl38.meaning source_38_meaning
192204: FROM xla_events_gt xet
192205: , CST_XLA_INV_HEADERS_V h1
192206: , fnd_lookup_values fvl12
192207: , fnd_lookup_values fvl38
192208: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192209: and xet.event_type_code = C_EVENT_TYPE_CODE
193052: FROM (
193053: SELECT xet.event_id event_id
193054: , 0 line_number
193055: , CASE r
193056: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
193057: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
193058:
193059: ELSE null
193060: END object_name
193053: SELECT xet.event_id event_id
193054: , 0 line_number
193055: , CASE r
193056: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
193057: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
193058:
193059: ELSE null
193060: END object_name
193061: , CASE r
193089:
193090: ELSE null
193091: END source_meaning
193092: FROM xla_events_gt xet
193093: , CST_XLA_INV_HEADERS_V h1
193094: , fnd_lookup_values fvl12
193095: , fnd_lookup_values fvl38
193096: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
193097: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193374: --
193375: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193376: --
193377:
193378: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
193379: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
193380:
193381: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
193382: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193375: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193376: --
193377:
193378: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
193379: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
193380:
193381: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
193382: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193383: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193437: , fvl12.meaning source_12_meaning
193438: , h1.TRANSFER_TO_GL_INDICATOR source_38
193439: , fvl38.meaning source_38_meaning
193440: FROM xla_events_gt xet
193441: , CST_XLA_INV_HEADERS_V h1
193442: , fnd_lookup_values fvl12
193443: , fnd_lookup_values fvl38
193444: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
193445: and xet.event_type_code = C_EVENT_TYPE_CODE
197921: FROM (
197922: SELECT xet.event_id event_id
197923: , 0 line_number
197924: , CASE r
197925: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
197926: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
197927:
197928: ELSE null
197929: END object_name
197922: SELECT xet.event_id event_id
197923: , 0 line_number
197924: , CASE r
197925: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
197926: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
197927:
197928: ELSE null
197929: END object_name
197930: , CASE r
197958:
197959: ELSE null
197960: END source_meaning
197961: FROM xla_events_gt xet
197962: , CST_XLA_INV_HEADERS_V h1
197963: , fnd_lookup_values fvl12
197964: , fnd_lookup_values fvl38
197965: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
197966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198244: --
198245: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198246: --
198247:
198248: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198249: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
198250:
198251: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
198252: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
198245: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198246: --
198247:
198248: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198249: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
198250:
198251: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
198252: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
198253: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
198306: , fvl12.meaning source_12_meaning
198307: , h1.TRANSFER_TO_GL_INDICATOR source_38
198308: , fvl38.meaning source_38_meaning
198309: FROM xla_events_gt xet
198310: , CST_XLA_INV_HEADERS_V h1
198311: , fnd_lookup_values fvl12
198312: , fnd_lookup_values fvl38
198313: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198314: and xet.event_class_code = C_EVENT_CLASS_CODE