DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000020_BC_PKG dependencies on PSA_CST_XLA_UPG_V

Line 13871: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'

13867: WHEN 7 THEN 'CST_XLA_RCV_REF_V'
13868: WHEN 8 THEN 'PO_DISTS_REF_V'
13869: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
13870: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
13871: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
13872: WHEN 12 THEN 'PO_HEADERS_REF_V'
13873: WHEN 13 THEN 'CST_XLA_RCV_REF_V'
13874: WHEN 14 THEN 'PO_DISTS_REF_V'
13875: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'

Line 13967: , PSA_CST_XLA_UPG_V h6

13963: , CST_XLA_RCV_HEADERS_V h1
13964: , CST_XLA_RCV_REF_V h3
13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6
13968: , fnd_lookup_values fvl9
13969: , fnd_lookup_values fvl42
13970: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 14228: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

14224: TYPE t_array_source_23 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
14225: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
14226: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
14227: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
14228: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
14229: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
14230: TYPE t_array_source_30 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
14231: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
14232: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 14309: , PSA_CST_XLA_UPG_V h6

14305: , CST_XLA_RCV_HEADERS_V h1
14306: , CST_XLA_RCV_REF_V h3
14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14309: , PSA_CST_XLA_UPG_V h6
14310: , fnd_lookup_values fvl9
14311: , fnd_lookup_values fvl42
14312: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
14313: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'

15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_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'

Line 15290: , PSA_CST_XLA_UPG_V h9

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)
15294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_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;

Line 15650: , PSA_CST_XLA_UPG_V h9

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
15654: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'

18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_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'

Line 19114: , PSA_CST_XLA_UPG_V h9

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)
19118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_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;

Line 19481: , PSA_CST_XLA_UPG_V h9

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
19485: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'

20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_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'

Line 20454: , PSA_CST_XLA_UPG_V h9

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)
20458: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_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;

Line 20821: , PSA_CST_XLA_UPG_V h9

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
20825: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 26526: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'
26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'
26526: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
26527: WHEN 18 THEN 'PO_HEADERS_REF_V'
26528: WHEN 19 THEN 'PO_DISTS_REF_V'
26529: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
26530:

Line 26644: , PSA_CST_XLA_UPG_V h9

26640: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
26641: , CST_XLA_INV_TXN_TYPES_REF_V h6
26642: , PO_DISTS_REF_V h7
26643: , PO_HEADERS_REF_V h8
26644: , PSA_CST_XLA_UPG_V h9
26645: , fnd_lookup_values fvl9
26646: , fnd_lookup_values fvl42
26647: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
26648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 26916: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26916: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
26917: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
26918: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
26920:

Line 27012: , PSA_CST_XLA_UPG_V h9

27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
27009: , CST_XLA_INV_TXN_TYPES_REF_V h6
27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8
27012: , PSA_CST_XLA_UPG_V h9
27013: , fnd_lookup_values fvl9
27014: , fnd_lookup_values fvl42
27015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
27016: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 27902: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'
27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'
27902: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
27903: WHEN 18 THEN 'PO_HEADERS_REF_V'
27904: WHEN 19 THEN 'PO_DISTS_REF_V'
27905: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
27906:

Line 28020: , PSA_CST_XLA_UPG_V h9

28016: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28017: , CST_XLA_INV_TXN_TYPES_REF_V h6
28018: , PO_DISTS_REF_V h7
28019: , PO_HEADERS_REF_V h8
28020: , PSA_CST_XLA_UPG_V h9
28021: , fnd_lookup_values fvl9
28022: , fnd_lookup_values fvl42
28023: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
28024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 28292: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28292: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
28293: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
28294: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
28296:

Line 28388: , PSA_CST_XLA_UPG_V h9

28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28385: , CST_XLA_INV_TXN_TYPES_REF_V h6
28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8
28388: , PSA_CST_XLA_UPG_V h9
28389: , fnd_lookup_values fvl9
28390: , fnd_lookup_values fvl42
28391: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
28392: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 29278: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'
29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'
29278: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
29279: WHEN 18 THEN 'PO_HEADERS_REF_V'
29280: WHEN 19 THEN 'PO_DISTS_REF_V'
29281: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
29282:

Line 29396: , PSA_CST_XLA_UPG_V h9

29392: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29393: , CST_XLA_INV_TXN_TYPES_REF_V h6
29394: , PO_DISTS_REF_V h7
29395: , PO_HEADERS_REF_V h8
29396: , PSA_CST_XLA_UPG_V h9
29397: , fnd_lookup_values fvl9
29398: , fnd_lookup_values fvl42
29399: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
29400: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 29668: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29668: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29669: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29670: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29672:

Line 29764: , PSA_CST_XLA_UPG_V h9

29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29761: , CST_XLA_INV_TXN_TYPES_REF_V h6
29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8
29764: , PSA_CST_XLA_UPG_V h9
29765: , fnd_lookup_values fvl9
29766: , fnd_lookup_values fvl42
29767: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29768: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 31950: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'
31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'
31950: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
31951: WHEN 18 THEN 'PO_HEADERS_REF_V'
31952: WHEN 19 THEN 'PO_DISTS_REF_V'
31953: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
31954:

Line 32068: , PSA_CST_XLA_UPG_V h9

32064: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32065: , CST_XLA_INV_TXN_TYPES_REF_V h6
32066: , PO_DISTS_REF_V h7
32067: , PO_HEADERS_REF_V h8
32068: , PSA_CST_XLA_UPG_V h9
32069: , fnd_lookup_values fvl9
32070: , fnd_lookup_values fvl42
32071: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
32072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 32340: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
32340: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
32341: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
32342: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
32344:

Line 32436: , PSA_CST_XLA_UPG_V h9

32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32433: , CST_XLA_INV_TXN_TYPES_REF_V h6
32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8
32436: , PSA_CST_XLA_UPG_V h9
32437: , fnd_lookup_values fvl9
32438: , fnd_lookup_values fvl42
32439: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
32440: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 33326: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'
33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'
33326: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
33327: WHEN 18 THEN 'PO_HEADERS_REF_V'
33328: WHEN 19 THEN 'PO_DISTS_REF_V'
33329: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
33330:

Line 33444: , PSA_CST_XLA_UPG_V h9

33440: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33441: , CST_XLA_INV_TXN_TYPES_REF_V h6
33442: , PO_DISTS_REF_V h7
33443: , PO_HEADERS_REF_V h8
33444: , PSA_CST_XLA_UPG_V h9
33445: , fnd_lookup_values fvl9
33446: , fnd_lookup_values fvl42
33447: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
33448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 33716: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
33716: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
33717: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
33718: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
33720:

Line 33812: , PSA_CST_XLA_UPG_V h9

33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33809: , CST_XLA_INV_TXN_TYPES_REF_V h6
33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8
33812: , PSA_CST_XLA_UPG_V h9
33813: , fnd_lookup_values fvl9
33814: , fnd_lookup_values fvl42
33815: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
33816: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 34702: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'
34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'
34702: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
34703: WHEN 18 THEN 'PO_HEADERS_REF_V'
34704: WHEN 19 THEN 'PO_DISTS_REF_V'
34705: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
34706:

Line 34820: , PSA_CST_XLA_UPG_V h9

34816: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
34817: , CST_XLA_INV_TXN_TYPES_REF_V h6
34818: , PO_DISTS_REF_V h7
34819: , PO_HEADERS_REF_V h8
34820: , PSA_CST_XLA_UPG_V h9
34821: , fnd_lookup_values fvl9
34822: , fnd_lookup_values fvl42
34823: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
34824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 35092: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
35092: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
35093: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
35094: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
35096:

Line 35188: , PSA_CST_XLA_UPG_V h9

35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
35185: , CST_XLA_INV_TXN_TYPES_REF_V h6
35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8
35188: , PSA_CST_XLA_UPG_V h9
35189: , fnd_lookup_values fvl9
35190: , fnd_lookup_values fvl42
35191: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
35192: and xet.event_type_code = C_EVENT_TYPE_CODE