DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000007_PKG dependencies on PO_REQ_HEADERS_REF_V

Line 143400: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_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

Line 143480: , PO_REQ_HEADERS_REF_V h5

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

Line 143777: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%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;
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;

Line 143862: , PO_REQ_HEADERS_REF_V h5

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
143864: , fnd_lookup_values fvl12
143865: , fnd_lookup_values fvl38
143866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 146420: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_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

Line 146500: , PO_REQ_HEADERS_REF_V h5

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

Line 146797: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%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;
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;

Line 146882: , PO_REQ_HEADERS_REF_V h5

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
146884: , fnd_lookup_values fvl12
146885: , fnd_lookup_values fvl38
146886: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 150579: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_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

Line 150659: , PO_REQ_HEADERS_REF_V h5

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

Line 150956: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%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;
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;

Line 151041: , PO_REQ_HEADERS_REF_V h5

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
151043: , fnd_lookup_values fvl12
151044: , fnd_lookup_values fvl38
151045: WHERE xet.event_date between p_pad_start_date and p_pad_end_date