eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_TRANSACTIONS_S_V

Line 52781: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

52777: FROM (
52778: SELECT xet.event_id event_id
52779: , 0 line_number
52780: , CASE r
52781: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
52782: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
52783: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
52784: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
52785: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 52785: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

52781: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
52782: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
52783: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
52784: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
52785: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
52786: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
52787: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
52788: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
52789:

Line 52847: , AR_TRANSACTIONS_S_V h7

52843: , AR_ADJUSTMENTS_H_V h1
52844: , AR_BILL_TO_CUSTOMERS_S_V h2
52845: , AR_BILL_TO_SITE_USES_S_V h3
52846: , AR_RECEIVABLES_TRX_ACT_S_V h6
52847: , AR_TRANSACTIONS_S_V h7
52848: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
52849: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52850: AND xet.event_class_code = C_EVENT_CLASS_CODE
52851: AND h1.event_id = xet.event_id

Line 53135: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

53131: --
53132: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53133: --
53134:
53135: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53136: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53137: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53138: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53139: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53139: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

53135: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53136: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53137: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53138: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53139: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53140: TYPE t_array_source_71 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53141: TYPE t_array_source_72 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53142: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53143:

Line 53217: , AR_TRANSACTIONS_S_V h7

53213: , AR_ADJUSTMENTS_H_V h1
53214: , AR_BILL_TO_CUSTOMERS_S_V h2
53215: , AR_BILL_TO_SITE_USES_S_V h3
53216: , AR_RECEIVABLES_TRX_ACT_S_V h6
53217: , AR_TRANSACTIONS_S_V h7
53218: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53219: and xet.event_class_code = C_EVENT_CLASS_CODE
53220: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
53221: AND h2.event_id = h1.event_id

Line 54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

54180: , 0 line_number
54181: , CASE r
54182: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

54181: , CASE r
54182: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54189:

Line 54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

54182: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54189:
54190: ELSE null

Line 54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54189:
54190: ELSE null
54191: END object_name

Line 54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54188: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54189:
54190: ELSE null
54191: END object_name
54192: , CASE r

Line 54241: , AR_TRANSACTIONS_S_V h5

54237: , null source_meaning
54238: FROM xla_events_gt xet
54239: , AR_BILL_TO_CUSTOMERS_S_V h1
54240: , AR_BILL_TO_SITE_USES_S_V h2
54241: , AR_TRANSACTIONS_S_V h5
54242: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54244: AND xet.event_class_code = C_EVENT_CLASS_CODE
54245: AND h1.event_id = xet.event_id

Line 54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

54520: --
54521:
54522: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54523: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

54521:
54522: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54523: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:

Line 54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

54522: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54523: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

54523: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 54597: , AR_TRANSACTIONS_S_V h5

54593: , h5.TRX_DOC_SEQUENCE_VALUE source_77
54594: FROM xla_events_gt xet
54595: , AR_BILL_TO_CUSTOMERS_S_V h1
54596: , AR_BILL_TO_SITE_USES_S_V h2
54597: , AR_TRANSACTIONS_S_V h5
54598: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54599: and xet.event_class_code = C_EVENT_CLASS_CODE
54600: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
54601: AND h2.event_id = h1.event_id

Line 57047: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

57043: FROM (
57044: SELECT xet.event_id event_id
57045: , 0 line_number
57046: , CASE r
57047: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

57046: , CASE r
57047: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

57047: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57056:

Line 57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57056:
57057: ELSE null

Line 57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57056:
57057: ELSE null
57058: END object_name

Line 57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57054: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57055: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57056:
57057: ELSE null
57058: END object_name
57059: , CASE r

Line 57116: , AR_TRANSACTIONS_S_V h5

57112: , null source_meaning
57113: FROM xla_events_gt xet
57114: , AR_BILL_TO_CUSTOMERS_S_V h1
57115: , AR_BILL_TO_SITE_USES_S_V h2
57116: , AR_TRANSACTIONS_S_V h5
57117: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57119: AND xet.event_class_code = C_EVENT_CLASS_CODE
57120: AND h1.event_id = xet.event_id

Line 57402: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

57398: --
57399: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57400: --
57401:
57402: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

57401:
57402: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

57402: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:

Line 57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57485: , AR_TRANSACTIONS_S_V h5

57481: , h5.TRX_DOC_SEQUENCE_VALUE source_77
57482: FROM xla_events_gt xet
57483: , AR_BILL_TO_CUSTOMERS_S_V h1
57484: , AR_BILL_TO_SITE_USES_S_V h2
57485: , AR_TRANSACTIONS_S_V h5
57486: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57487: and xet.event_class_code = C_EVENT_CLASS_CODE
57488: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
57489: AND h2.event_id = h1.event_id

Line 58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

58516: , 0 line_number
58517: , CASE r
58518: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

58517: , CASE r
58518: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58525:

Line 58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

58518: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58525:
58526: ELSE null

Line 58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58525:
58526: ELSE null
58527: END object_name

Line 58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58524: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58525:
58526: ELSE null
58527: END object_name
58528: , CASE r

Line 58577: , AR_TRANSACTIONS_S_V h5

58573: , null source_meaning
58574: FROM xla_events_gt xet
58575: , AR_BILL_TO_CUSTOMERS_S_V h1
58576: , AR_BILL_TO_SITE_USES_S_V h2
58577: , AR_TRANSACTIONS_S_V h5
58578: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58580: AND xet.event_class_code = C_EVENT_CLASS_CODE
58581: AND h1.event_id = xet.event_id

Line 58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

58856: --
58857:
58858: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
58859: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

58857:
58858: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
58859: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:

Line 58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

58858: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
58859: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

58859: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58933: , AR_TRANSACTIONS_S_V h5

58929: , h5.TRX_DOC_SEQUENCE_VALUE source_77
58930: FROM xla_events_gt xet
58931: , AR_BILL_TO_CUSTOMERS_S_V h1
58932: , AR_BILL_TO_SITE_USES_S_V h2
58933: , AR_TRANSACTIONS_S_V h5
58934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58935: and xet.event_class_code = C_EVENT_CLASS_CODE
58936: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
58937: AND h2.event_id = h1.event_id

Line 59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

59762: , 0 line_number
59763: , CASE r
59764: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

59763: , CASE r
59764: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
59771:

Line 59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

59764: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
59771:
59772: ELSE null

Line 59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
59771:
59772: ELSE null
59773: END object_name

Line 59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
59770: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
59771:
59772: ELSE null
59773: END object_name
59774: , CASE r

Line 59823: , AR_TRANSACTIONS_S_V h5

59819: , null source_meaning
59820: FROM xla_events_gt xet
59821: , AR_BILL_TO_CUSTOMERS_S_V h1
59822: , AR_BILL_TO_SITE_USES_S_V h2
59823: , AR_TRANSACTIONS_S_V h5
59824: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
59825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59826: AND xet.event_class_code = C_EVENT_CLASS_CODE
59827: AND h1.event_id = xet.event_id

Line 60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

60102: --
60103:
60104: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60105: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

60103:
60104: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60105: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:

Line 60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

60104: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60105: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

60105: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 60179: , AR_TRANSACTIONS_S_V h5

60175: , h5.TRX_DOC_SEQUENCE_VALUE source_77
60176: FROM xla_events_gt xet
60177: , AR_BILL_TO_CUSTOMERS_S_V h1
60178: , AR_BILL_TO_SITE_USES_S_V h2
60179: , AR_TRANSACTIONS_S_V h5
60180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60181: and xet.event_class_code = C_EVENT_CLASS_CODE
60182: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
60183: AND h2.event_id = h1.event_id

Line 61010: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

61006: FROM (
61007: SELECT xet.event_id event_id
61008: , 0 line_number
61009: , CASE r
61010: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

61009: , CASE r
61010: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

61010: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61019:

Line 61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61019:
61020: ELSE null

Line 61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61019:
61020: ELSE null
61021: END object_name

Line 61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61017: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61018: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61019:
61020: ELSE null
61021: END object_name
61022: , CASE r

Line 61079: , AR_TRANSACTIONS_S_V h5

61075: , null source_meaning
61076: FROM xla_events_gt xet
61077: , AR_BILL_TO_CUSTOMERS_S_V h1
61078: , AR_BILL_TO_SITE_USES_S_V h2
61079: , AR_TRANSACTIONS_S_V h5
61080: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61082: AND xet.event_class_code = C_EVENT_CLASS_CODE
61083: AND h1.event_id = xet.event_id

Line 61370: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

61366: --
61367: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61368: --
61369:
61370: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

61369:
61370: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

61370: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:

Line 61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61455: , AR_TRANSACTIONS_S_V h5

61451: , h5.TRX_DOC_SEQUENCE_VALUE source_77
61452: FROM xla_events_gt xet
61453: , AR_BILL_TO_CUSTOMERS_S_V h1
61454: , AR_BILL_TO_SITE_USES_S_V h2
61455: , AR_TRANSACTIONS_S_V h5
61456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61457: and xet.event_class_code = C_EVENT_CLASS_CODE
61458: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
61459: AND h2.event_id = h1.event_id

Line 64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'

64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'

64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64374: , AR_TRANSACTIONS_S_V l10

64370: , AR_CUST_TRX_LINES_L_V l2
64371: , AR_DISTRIBUTIONS_BASE_V l3
64372: , AR_DISTRIBUTIONS_L_V l4
64373: , AR_RECEIVABLES_TRX_ACT_S_V l7
64374: , AR_TRANSACTIONS_S_V l10
64375: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64377: AND xet.event_class_code = C_EVENT_CLASS_CODE
64378: AND l3.event_id = xet.event_id

Line 64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64741: , AR_TRANSACTIONS_S_V l10

64737: , AR_CUST_TRX_LINES_L_V l2
64738: , AR_DISTRIBUTIONS_BASE_V l3
64739: , AR_DISTRIBUTIONS_L_V l4
64740: , AR_RECEIVABLES_TRX_ACT_S_V l7
64741: , AR_TRANSACTIONS_S_V l10
64742: WHERE xet.event_id between x_first_event_id and x_last_event_id
64743: and xet.event_date between p_pad_start_date and p_pad_end_date
64744: and xet.event_class_code = C_EVENT_CLASS_CODE
64745: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id