DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000020_BC_PKG dependencies on PO_REQ_HEADERS_REF_V

Line 15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'
15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'
15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'
15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'
15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 15174: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'
15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'
15173: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
15174: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
15175: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
15176:
15177: ELSE null
15178: END object_name

Line 15289: , PO_REQ_HEADERS_REF_V h8

15285: , CST_XLA_INV_REF_V h4
15286: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15287: , CST_XLA_INV_TXN_TYPES_REF_V h6
15288: , PO_REQ_DISTS_REF_V h7
15289: , PO_REQ_HEADERS_REF_V h8
15290: , PSA_CST_XLA_UPG_V h9
15291: , fnd_lookup_values fvl9
15292: , fnd_lookup_values fvl42
15293: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
15549: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
15561:
15562: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
15563: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 15649: , PO_REQ_HEADERS_REF_V h8

15645: , CST_XLA_INV_REF_V h4
15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15647: , CST_XLA_INV_TXN_TYPES_REF_V h6
15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8
15650: , PSA_CST_XLA_UPG_V h9
15651: , fnd_lookup_values fvl9
15652: , fnd_lookup_values fvl42
15653: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'
18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'
18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'
18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'
18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 18998: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'
18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'
18997: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
18998: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
18999: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
19000:
19001: ELSE null
19002: END object_name

Line 19113: , PO_REQ_HEADERS_REF_V h8

19109: , CST_XLA_INV_REF_V h4
19110: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19111: , CST_XLA_INV_TXN_TYPES_REF_V h6
19112: , PO_REQ_DISTS_REF_V h7
19113: , PO_REQ_HEADERS_REF_V h8
19114: , PSA_CST_XLA_UPG_V h9
19115: , fnd_lookup_values fvl9
19116: , fnd_lookup_values fvl42
19117: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
19377: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
19389:
19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 19480: , PO_REQ_HEADERS_REF_V h8

19476: , CST_XLA_INV_REF_V h4
19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19478: , CST_XLA_INV_TXN_TYPES_REF_V h6
19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8
19481: , PSA_CST_XLA_UPG_V h9
19482: , fnd_lookup_values fvl9
19483: , fnd_lookup_values fvl42
19484: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'
20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'
20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'
20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'
20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 20338: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'
20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'
20337: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
20338: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
20339: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
20340:
20341: ELSE null
20342: END object_name

Line 20453: , PO_REQ_HEADERS_REF_V h8

20449: , CST_XLA_INV_REF_V h4
20450: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20451: , CST_XLA_INV_TXN_TYPES_REF_V h6
20452: , PO_REQ_DISTS_REF_V h7
20453: , PO_REQ_HEADERS_REF_V h8
20454: , PSA_CST_XLA_UPG_V h9
20455: , fnd_lookup_values fvl9
20456: , fnd_lookup_values fvl42
20457: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
20717: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
20729:
20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 20820: , PO_REQ_HEADERS_REF_V h8

20816: , CST_XLA_INV_REF_V h4
20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20818: , CST_XLA_INV_TXN_TYPES_REF_V h6
20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8
20821: , PSA_CST_XLA_UPG_V h9
20822: , fnd_lookup_values fvl9
20823: , fnd_lookup_values fvl42
20824: WHERE xet.event_date between p_pad_start_date and p_pad_end_date