DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000007_PKG dependencies on PSA_CST_XLA_UPG_V

Line 142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'

142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
142065:
142066: ELSE null
142067: END object_name

Line 142160: , PSA_CST_XLA_UPG_V h6

142156: , CST_XLA_RCV_HEADERS_V h1
142157: , CST_XLA_RCV_REF_V h3
142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6
142161: , fnd_lookup_values fvl12
142162: , fnd_lookup_values fvl38
142163: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
142164: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142526: , PSA_CST_XLA_UPG_V h6

142522: , CST_XLA_RCV_HEADERS_V h1
142523: , CST_XLA_RCV_REF_V h3
142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5
142526: , PSA_CST_XLA_UPG_V h6
142527: , fnd_lookup_values fvl12
142528: , fnd_lookup_values fvl38
142529: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142530: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_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'

Line 143481: , PSA_CST_XLA_UPG_V h6

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

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

143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;

Line 143863: , PSA_CST_XLA_UPG_V h6

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

Line 146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_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'

Line 146501: , PSA_CST_XLA_UPG_V h6

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

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

146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;

Line 146883: , PSA_CST_XLA_UPG_V h6

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

Line 150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_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'

Line 150660: , PSA_CST_XLA_UPG_V h6

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

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

150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;

Line 151042: , PSA_CST_XLA_UPG_V h6

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

Line 164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'

164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'
164950: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
164951:
164952: ELSE null

Line 165030: , PSA_CST_XLA_UPG_V h6

165026: , CST_XLA_INV_HEADERS_V h1
165027: , CST_XLA_INV_REF_V h3
165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165031: , fnd_lookup_values fvl12
165032: , fnd_lookup_values fvl38
165033: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
165034: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165325: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
165326: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
165327: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165328:
165329: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165412: , PSA_CST_XLA_UPG_V h6

165408: , CST_XLA_INV_HEADERS_V h1
165409: , CST_XLA_INV_REF_V h3
165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5
165412: , PSA_CST_XLA_UPG_V h6
165413: , fnd_lookup_values fvl12
165414: , fnd_lookup_values fvl38
165415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165416: and xet.event_class_code = C_EVENT_CLASS_CODE