DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000005_PKG dependencies on PO_REQ_HEADERS_REF_V

Line 148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
148393: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
148394:
148395: ELSE null
148396: END object_name

Line 148472: , PO_REQ_HEADERS_REF_V h5

148468: FROM xla_events_gt xet
148469: , CST_XLA_INV_HEADERS_V h1
148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12
148475: , fnd_lookup_values fvl38
148476: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

Line 148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
148770: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
148771:
148772: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
148773: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 148854: , PO_REQ_HEADERS_REF_V h5

148850: FROM xla_events_gt xet
148851: , CST_XLA_INV_HEADERS_V h1
148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
148856: , fnd_lookup_values fvl12
148857: , fnd_lookup_values fvl38
148858: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
151413: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
151414:
151415: ELSE null
151416: END object_name

Line 151492: , PO_REQ_HEADERS_REF_V h5

151488: FROM xla_events_gt xet
151489: , CST_XLA_INV_HEADERS_V h1
151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12
151495: , fnd_lookup_values fvl38
151496: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

Line 151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
151790: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
151791:
151792: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
151793: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 151874: , PO_REQ_HEADERS_REF_V h5

151870: FROM xla_events_gt xet
151871: , CST_XLA_INV_HEADERS_V h1
151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
151876: , fnd_lookup_values fvl12
151877: , fnd_lookup_values fvl38
151878: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
155572: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
155573:
155574: ELSE null
155575: END object_name

Line 155651: , PO_REQ_HEADERS_REF_V h5

155647: FROM xla_events_gt xet
155648: , CST_XLA_INV_HEADERS_V h1
155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12
155654: , fnd_lookup_values fvl38
155655: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

Line 155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
155949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
155950:
155951: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
155952: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 156033: , PO_REQ_HEADERS_REF_V h5

156029: FROM xla_events_gt xet
156030: , CST_XLA_INV_HEADERS_V h1
156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156035: , fnd_lookup_values fvl12
156036: , fnd_lookup_values fvl38
156037: WHERE xet.event_date between p_pad_start_date and p_pad_end_date