[Home] [Help]
5977: WHEN 8 THEN 'PO_DISTS_REF_V'
5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'
5982: WHEN 13 THEN 'PO_HEADERS_REF_V'
5983: WHEN 14 THEN 'CST_XLA_RCV_REF_V'
5984: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'
5985:
6072: , CST_XLA_RCV_HEADERS_V h1
6073: , CST_XLA_RCV_REF_V h3
6074: , PO_DISTS_REF_V h4
6075: , PO_HEADERS_REF_V h5
6076: , PSA_CST_XLA_UPG_V h6
6077: , fnd_lookup_values fvl13
6078: , fnd_lookup_values fvl37
6079: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
6080: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6338: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6341: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6342:
6414: , CST_XLA_RCV_HEADERS_V h1
6415: , CST_XLA_RCV_REF_V h3
6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5
6418: , PSA_CST_XLA_UPG_V h6
6419: , fnd_lookup_values fvl13
6420: , fnd_lookup_values fvl37
6421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6422: and xet.event_class_code = C_EVENT_CLASS_CODE
7266: WHEN 2 THEN 'CST_XLA_INV_REF_V'
7267: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
7268: WHEN 4 THEN 'CST_XLA_INV_REF_V'
7269: WHEN 5 THEN 'CST_XLA_INV_REF_V'
7270: WHEN 6 THEN 'PSA_CST_XLA_UPG_V'
7271: WHEN 7 THEN 'PO_REQ_HEADERS_REF_V'
7272: WHEN 8 THEN 'PO_REQ_DISTS_REF_V'
7273: WHEN 9 THEN 'CST_XLA_INV_REF_V'
7274: WHEN 10 THEN 'CST_XLA_INV_REF_V'
7368: , CST_XLA_INV_ORG_PARAMS_REF_V h3
7369: , CST_XLA_INV_REF_V h4
7370: , PO_REQ_DISTS_REF_V h5
7371: , PO_REQ_HEADERS_REF_V h6
7372: , PSA_CST_XLA_UPG_V h7
7373: , fnd_lookup_values fvl13
7374: , fnd_lookup_values fvl37
7375: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
7376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7624: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
7625: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7626: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
7627: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
7628: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
7629: TYPE t_array_source_28 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
7630: TYPE t_array_source_29 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
7631: TYPE t_array_source_30 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
7632: TYPE t_array_source_31 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
7711: , CST_XLA_INV_ORG_PARAMS_REF_V h3
7712: , CST_XLA_INV_REF_V h4
7713: , PO_REQ_DISTS_REF_V h5
7714: , PO_REQ_HEADERS_REF_V h6
7715: , PSA_CST_XLA_UPG_V h7
7716: , fnd_lookup_values fvl13
7717: , fnd_lookup_values fvl37
7718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7719: and xet.event_class_code = C_EVENT_CLASS_CODE
8529: WHEN 2 THEN 'CST_XLA_INV_REF_V'
8530: WHEN 3 THEN 'CST_XLA_INV_HEADERS_V'
8531: WHEN 4 THEN 'CST_XLA_INV_REF_V'
8532: WHEN 5 THEN 'CST_XLA_INV_REF_V'
8533: WHEN 6 THEN 'PSA_CST_XLA_UPG_V'
8534: WHEN 7 THEN 'PO_REQ_HEADERS_REF_V'
8535: WHEN 8 THEN 'PO_REQ_DISTS_REF_V'
8536: WHEN 9 THEN 'CST_XLA_INV_REF_V'
8537: WHEN 10 THEN 'CST_XLA_INV_REF_V'
8631: , CST_XLA_INV_ORG_PARAMS_REF_V h3
8632: , CST_XLA_INV_REF_V h4
8633: , PO_REQ_DISTS_REF_V h5
8634: , PO_REQ_HEADERS_REF_V h6
8635: , PSA_CST_XLA_UPG_V h7
8636: , fnd_lookup_values fvl13
8637: , fnd_lookup_values fvl37
8638: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
8639: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8892: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8893: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8894: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
8895: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8896: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
8897: TYPE t_array_source_28 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
8898: TYPE t_array_source_29 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
8899: TYPE t_array_source_30 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
8900: TYPE t_array_source_31 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8981: , CST_XLA_INV_ORG_PARAMS_REF_V h3
8982: , CST_XLA_INV_REF_V h4
8983: , PO_REQ_DISTS_REF_V h5
8984: , PO_REQ_HEADERS_REF_V h6
8985: , PSA_CST_XLA_UPG_V h7
8986: , fnd_lookup_values fvl13
8987: , fnd_lookup_values fvl37
8988: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8989: and xet.event_class_code = C_EVENT_CLASS_CODE
13461: WHEN 9 THEN 'CST_XLA_INV_HEADERS_V'
13462: WHEN 10 THEN 'PO_DISTS_REF_V'
13463: WHEN 11 THEN 'CST_XLA_INV_REF_V'
13464: WHEN 12 THEN 'CST_XLA_INV_REF_V'
13465: WHEN 13 THEN 'PSA_CST_XLA_UPG_V'
13466: WHEN 14 THEN 'PO_HEADERS_REF_V'
13467: WHEN 15 THEN 'CST_XLA_INV_HEADERS_V'
13468:
13469: ELSE null
13556: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13557: , CST_XLA_INV_REF_V h4
13558: , PO_DISTS_REF_V h5
13559: , PO_HEADERS_REF_V h6
13560: , PSA_CST_XLA_UPG_V h7
13561: , fnd_lookup_values fvl13
13562: , fnd_lookup_values fvl37
13563: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13824: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13825: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
13826: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
13827: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13828: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
13830: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13831:
13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
13906: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13907: , CST_XLA_INV_REF_V h4
13908: , PO_DISTS_REF_V h5
13909: , PO_HEADERS_REF_V h6
13910: , PSA_CST_XLA_UPG_V h7
13911: , fnd_lookup_values fvl13
13912: , fnd_lookup_values fvl37
13913: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13914: and xet.event_class_code = C_EVENT_CLASS_CODE