DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000007_PKG dependencies on PO_HEADERS_REF_V

Line 142062: WHEN 14 THEN 'PO_HEADERS_REF_V'

142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
142065:
142066: ELSE null

Line 142159: , PO_HEADERS_REF_V h5

142155: FROM xla_events_gt xet
142156: , CST_XLA_RCV_HEADERS_V h1
142157: , CST_XLA_RCV_REF_V h3
142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6
142161: , fnd_lookup_values fvl12
142162: , fnd_lookup_values fvl38
142163: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142525: , PO_HEADERS_REF_V h5

142521: FROM xla_events_gt xet
142522: , CST_XLA_RCV_HEADERS_V h1
142523: , CST_XLA_RCV_REF_V h3
142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5
142526: , PSA_CST_XLA_UPG_V h6
142527: , fnd_lookup_values fvl12
142528: , fnd_lookup_values fvl38
142529: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 163566: WHEN 15 THEN 'PO_HEADERS_REF_V'

163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
163566: WHEN 15 THEN 'PO_HEADERS_REF_V'
163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
163568:
163569: ELSE null
163570: END object_name

Line 163662: , PO_HEADERS_REF_V h5

163658: FROM xla_events_gt xet
163659: , CST_XLA_RCV_HEADERS_V h1
163660: , CST_XLA_RCV_REF_V h3
163661: , PO_DISTS_REF_V h4
163662: , PO_HEADERS_REF_V h5
163663: , PSA_CST_XLA_PEA_UPG_V h6
163664: , fnd_lookup_values fvl12
163665: , fnd_lookup_values fvl38
163666: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

163939: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 164028: , PO_HEADERS_REF_V h5

164024: FROM xla_events_gt xet
164025: , CST_XLA_RCV_HEADERS_V h1
164026: , CST_XLA_RCV_REF_V h3
164027: , PO_DISTS_REF_V h4
164028: , PO_HEADERS_REF_V h5
164029: , PSA_CST_XLA_PEA_UPG_V h6
164030: , fnd_lookup_values fvl12
164031: , fnd_lookup_values fvl38
164032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 164947: WHEN 9 THEN 'PO_HEADERS_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'
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:

Line 165029: , PO_HEADERS_REF_V h5

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
165031: , fnd_lookup_values fvl12
165032: , fnd_lookup_values fvl38
165033: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

Line 165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_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;
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:

Line 165411: , PO_HEADERS_REF_V h5

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
165413: , fnd_lookup_values fvl12
165414: , fnd_lookup_values fvl38
165415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date