DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000002_PKG dependencies on PO_HEADERS_REF_V

Line 147054: WHEN 14 THEN 'PO_HEADERS_REF_V'

147050: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
147051: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
147052: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
147053: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
147054: WHEN 14 THEN 'PO_HEADERS_REF_V'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
147056: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
147057:
147058: ELSE null

Line 147151: , PO_HEADERS_REF_V h5

147147: FROM xla_events_gt xet
147148: , CST_XLA_RCV_HEADERS_V h1
147149: , CST_XLA_RCV_REF_V h3
147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12
147154: , fnd_lookup_values fvl38
147155: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

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

147427: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147428: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
147429: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
147430: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147431: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 147517: , PO_HEADERS_REF_V h5

147513: FROM xla_events_gt xet
147514: , CST_XLA_RCV_HEADERS_V h1
147515: , CST_XLA_RCV_REF_V h3
147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147518: , PSA_CST_XLA_UPG_V h6
147519: , fnd_lookup_values fvl12
147520: , fnd_lookup_values fvl38
147521: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 171059: WHEN 15 THEN 'PO_HEADERS_REF_V'

171055: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
171056: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
171057: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
171058: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
171059: WHEN 15 THEN 'PO_HEADERS_REF_V'
171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
171061:
171062: ELSE null
171063: END object_name

Line 171155: , PO_HEADERS_REF_V h5

171151: FROM xla_events_gt xet
171152: , CST_XLA_RCV_HEADERS_V h1
171153: , CST_XLA_RCV_REF_V h3
171154: , PO_DISTS_REF_V h4
171155: , PO_HEADERS_REF_V h5
171156: , PSA_CST_XLA_PEA_UPG_V h6
171157: , fnd_lookup_values fvl12
171158: , fnd_lookup_values fvl38
171159: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

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

171432: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
171433: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
171434: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
171435: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171521: , PO_HEADERS_REF_V h5

171517: FROM xla_events_gt xet
171518: , CST_XLA_RCV_HEADERS_V h1
171519: , CST_XLA_RCV_REF_V h3
171520: , PO_DISTS_REF_V h4
171521: , PO_HEADERS_REF_V h5
171522: , PSA_CST_XLA_PEA_UPG_V h6
171523: , fnd_lookup_values fvl12
171524: , fnd_lookup_values fvl38
171525: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 172440: WHEN 9 THEN 'PO_HEADERS_REF_V'

172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'
172443: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
172444:

Line 172522: , PO_HEADERS_REF_V h5

172518: FROM xla_events_gt xet
172519: , CST_XLA_INV_HEADERS_V h1
172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12
172525: , fnd_lookup_values fvl38
172526: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

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

172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
172820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
172821:

Line 172904: , PO_HEADERS_REF_V h5

172900: FROM xla_events_gt xet
172901: , CST_XLA_INV_HEADERS_V h1
172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
172906: , fnd_lookup_values fvl12
172907: , fnd_lookup_values fvl38
172908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date