[Home] [Help]
29088: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
29089: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
29090: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
29091: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
29092: WHEN 15 THEN 'PO_HEADERS_REF_V'
29093: WHEN 16 THEN 'CST_XLA_RCV_REF_V'
29094: WHEN 17 THEN 'CST_XLA_RCV_HEADERS_V'
29095:
29096: ELSE null
29189: FROM xla_events_gt xet
29190: , CST_XLA_RCV_HEADERS_V h1
29191: , CST_XLA_RCV_REF_V h3
29192: , PO_DISTS_REF_V h5
29193: , PO_HEADERS_REF_V h6
29194: , PSA_CST_XLA_UPG_V h7
29195: , fnd_lookup_values fvl13
29196: , fnd_lookup_values fvl36
29197: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
29516: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29517: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29518: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29519: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29520: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29521: TYPE t_array_source_33 IS TABLE OF CST_XLA_RCV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29522: TYPE t_array_source_36 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29523:
29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
29622: FROM xla_events_gt xet
29623: , CST_XLA_RCV_HEADERS_V h1
29624: , CST_XLA_RCV_REF_V h3
29625: , PO_DISTS_REF_V h5
29626: , PO_HEADERS_REF_V h6
29627: , PSA_CST_XLA_UPG_V h7
29628: , fnd_lookup_values fvl13
29629: , fnd_lookup_values fvl36
29630: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
31233: WHEN 10 THEN 'PO_HEADERS_REF_V'
31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31235: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31236: WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'
31237:
31315: FROM xla_events_gt xet
31316: , CST_XLA_INV_HEADERS_V h1
31317: , CST_XLA_INV_REF_V h3
31318: , PO_DISTS_REF_V h5
31319: , PO_HEADERS_REF_V h6
31320: , PSA_CST_XLA_UPG_V h7
31321: , fnd_lookup_values fvl13
31322: , fnd_lookup_values fvl36
31323: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31656: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31757: FROM xla_events_gt xet
31758: , CST_XLA_INV_HEADERS_V h1
31759: , CST_XLA_INV_REF_V h3
31760: , PO_DISTS_REF_V h5
31761: , PO_HEADERS_REF_V h6
31762: , PSA_CST_XLA_UPG_V h7
31763: , fnd_lookup_values fvl13
31764: , fnd_lookup_values fvl36
31765: WHERE xet.event_date between p_pad_start_date and p_pad_end_date