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_000005_PKG dependencies on AR_TRANSACTIONS_S_V

Line 66741: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

66737: , CASE r
66738: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66739: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66740: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
66741: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
66742: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'
66743: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
66744: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
66745:

Line 66799: , AR_TRANSACTIONS_S_V h7

66795: , AR_ADJUSTMENTS_H_V h1
66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66799: , AR_TRANSACTIONS_S_V h7
66800: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
66801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66802: AND xet.event_class_code = C_EVENT_CLASS_CODE
66803: AND h1.event_id = xet.event_id

Line 67090: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

67086:
67087: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
67088: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67089: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67090: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67091: TYPE t_array_source_77 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
67092: TYPE t_array_source_78 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67093: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
67094:

Line 67166: , AR_TRANSACTIONS_S_V h7

67162: , AR_ADJUSTMENTS_H_V h1
67163: , AR_BILL_TO_CUSTOMERS_S_V h2
67164: , AR_BILL_TO_SITE_USES_S_V h3
67165: , AR_RECEIVABLES_TRX_ACT_S_V h6
67166: , AR_TRANSACTIONS_S_V h7
67167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67168: and xet.event_class_code = C_EVENT_CLASS_CODE
67169: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
67170: AND h2.event_id = h1.event_id

Line 68189: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

68185: FROM (
68186: SELECT xet.event_id event_id
68187: , 0 line_number
68188: , CASE r
68189: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

68188: , CASE r
68189: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
68196:

Line 68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

68189: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
68196:
68197: ELSE null

Line 68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
68196:
68197: ELSE null
68198: END object_name

Line 68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
68196:
68197: ELSE null
68198: END object_name
68199: , CASE r

Line 68248: , AR_TRANSACTIONS_S_V h5

68244: , null source_meaning
68245: FROM xla_events_gt xet
68246: , AR_BILL_TO_CUSTOMERS_S_V h1
68247: , AR_BILL_TO_SITE_USES_S_V h2
68248: , AR_TRANSACTIONS_S_V h5
68249: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68250: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68251: AND xet.event_class_code = C_EVENT_CLASS_CODE
68252: AND h1.event_id = xet.event_id

Line 68529: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

68525: --
68526: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68527: --
68528:
68529: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68530: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

68528:
68529: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68530: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:

Line 68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

68529: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68530: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

68530: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68604: , AR_TRANSACTIONS_S_V h5

68600: , h5.TRX_DOC_SEQUENCE_ID source_82
68601: FROM xla_events_gt xet
68602: , AR_BILL_TO_CUSTOMERS_S_V h1
68603: , AR_BILL_TO_SITE_USES_S_V h2
68604: , AR_TRANSACTIONS_S_V h5
68605: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68606: and xet.event_class_code = C_EVENT_CLASS_CODE
68607: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
68608: AND h2.event_id = h1.event_id

Line 69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

69560: FROM (
69561: SELECT xet.event_id event_id
69562: , l3.line_number line_number
69563: , CASE r
69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

69561: SELECT xet.event_id event_id
69562: , l3.line_number line_number
69563: , CASE r
69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

69562: , l3.line_number line_number
69563: , CASE r
69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 69680: , AR_TRANSACTIONS_S_V l9

69676: , AR_CM_LINES_BASE_V l3
69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69680: , AR_TRANSACTIONS_S_V l9
69681: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69682: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69683: AND xet.event_class_code = C_EVENT_CLASS_CODE
69684: AND l3.event_id = xet.event_id

Line 69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69830: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69831: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69832:
69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

69830: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69831: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69832:
69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

69831: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69832:
69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69982: , AR_TRANSACTIONS_S_V l9

69978: , AR_CM_LINES_BASE_V l3
69979: , AR_CM_LINES_L_V l4
69980: , AR_DISTRIBUTIONS_L_V l6
69981: , AR_RECEIVABLES_TRX_ACT_S_V l7
69982: , AR_TRANSACTIONS_S_V l9
69983: WHERE xet.event_id between x_first_event_id and x_last_event_id
69984: and xet.event_date between p_pad_start_date and p_pad_end_date
69985: and xet.event_class_code = C_EVENT_CLASS_CODE
69986: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 71167: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

71163: FROM (
71164: SELECT xet.event_id event_id
71165: , 0 line_number
71166: , CASE r
71167: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

71166: , CASE r
71167: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71174:

Line 71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

71167: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71174:
71175: ELSE null

Line 71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71174:
71175: ELSE null
71176: END object_name

Line 71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71174:
71175: ELSE null
71176: END object_name
71177: , CASE r

Line 71226: , AR_TRANSACTIONS_S_V h5

71222: , null source_meaning
71223: FROM xla_events_gt xet
71224: , AR_BILL_TO_CUSTOMERS_S_V h1
71225: , AR_BILL_TO_SITE_USES_S_V h2
71226: , AR_TRANSACTIONS_S_V h5
71227: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
71228: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71229: AND xet.event_class_code = C_EVENT_CLASS_CODE
71230: AND h1.event_id = xet.event_id

Line 71512: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

71508: --
71509: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71510: --
71511:
71512: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71513: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

71511:
71512: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71513: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:

Line 71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

71512: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71513: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

71513: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71589: , AR_TRANSACTIONS_S_V h5

71585: , h5.TRX_DOC_SEQUENCE_ID source_82
71586: FROM xla_events_gt xet
71587: , AR_BILL_TO_CUSTOMERS_S_V h1
71588: , AR_BILL_TO_SITE_USES_S_V h2
71589: , AR_TRANSACTIONS_S_V h5
71590: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71591: and xet.event_class_code = C_EVENT_CLASS_CODE
71592: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
71593: AND h2.event_id = h1.event_id

Line 72648: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

72644: FROM (
72645: SELECT xet.event_id event_id
72646: , 0 line_number
72647: , CASE r
72648: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

72647: , CASE r
72648: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
72655:

Line 72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

72648: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
72655:
72656: ELSE null

Line 72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
72655:
72656: ELSE null
72657: END object_name

Line 72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
72655:
72656: ELSE null
72657: END object_name
72658: , CASE r

Line 72707: , AR_TRANSACTIONS_S_V h5

72703: , null source_meaning
72704: FROM xla_events_gt xet
72705: , AR_BILL_TO_CUSTOMERS_S_V h1
72706: , AR_BILL_TO_SITE_USES_S_V h2
72707: , AR_TRANSACTIONS_S_V h5
72708: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72709: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72710: AND xet.event_class_code = C_EVENT_CLASS_CODE
72711: AND h1.event_id = xet.event_id

Line 72988: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

72984: --
72985: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72986: --
72987:
72988: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72989: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

72987:
72988: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72989: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:

Line 72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

72988: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72989: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

72989: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73063: , AR_TRANSACTIONS_S_V h5

73059: , h5.TRX_DOC_SEQUENCE_ID source_82
73060: FROM xla_events_gt xet
73061: , AR_BILL_TO_CUSTOMERS_S_V h1
73062: , AR_BILL_TO_SITE_USES_S_V h2
73063: , AR_TRANSACTIONS_S_V h5
73064: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73065: and xet.event_class_code = C_EVENT_CLASS_CODE
73066: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
73067: AND h2.event_id = h1.event_id

Line 73894: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

73890: FROM (
73891: SELECT xet.event_id event_id
73892: , 0 line_number
73893: , CASE r
73894: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

73893: , CASE r
73894: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73901:

Line 73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

73894: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73901:
73902: ELSE null

Line 73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73901:
73902: ELSE null
73903: END object_name

Line 73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73901:
73902: ELSE null
73903: END object_name
73904: , CASE r

Line 73953: , AR_TRANSACTIONS_S_V h5

73949: , null source_meaning
73950: FROM xla_events_gt xet
73951: , AR_BILL_TO_CUSTOMERS_S_V h1
73952: , AR_BILL_TO_SITE_USES_S_V h2
73953: , AR_TRANSACTIONS_S_V h5
73954: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73956: AND xet.event_class_code = C_EVENT_CLASS_CODE
73957: AND h1.event_id = xet.event_id

Line 74234: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

74230: --
74231: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74232: --
74233:
74234: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74235: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

74233:
74234: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74235: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:

Line 74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

74234: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74235: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

74235: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74309: , AR_TRANSACTIONS_S_V h5

74305: , h5.TRX_DOC_SEQUENCE_ID source_82
74306: FROM xla_events_gt xet
74307: , AR_BILL_TO_CUSTOMERS_S_V h1
74308: , AR_BILL_TO_SITE_USES_S_V h2
74309: , AR_TRANSACTIONS_S_V h5
74310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74311: and xet.event_class_code = C_EVENT_CLASS_CODE
74312: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
74313: AND h2.event_id = h1.event_id

Line 75140: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

75136: FROM (
75137: SELECT xet.event_id event_id
75138: , 0 line_number
75139: , CASE r
75140: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75141: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

75138: , 0 line_number
75139: , CASE r
75140: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75141: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

75141: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75149:

Line 75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75149:
75150: ELSE null

Line 75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75149:
75150: ELSE null
75151: END object_name

Line 75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75149:
75150: ELSE null
75151: END object_name
75152: , CASE r

Line 75209: , AR_TRANSACTIONS_S_V h5

75205: , null source_meaning
75206: FROM xla_events_gt xet
75207: , AR_BILL_TO_CUSTOMERS_S_V h1
75208: , AR_BILL_TO_SITE_USES_S_V h2
75209: , AR_TRANSACTIONS_S_V h5
75210: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75211: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75212: AND xet.event_class_code = C_EVENT_CLASS_CODE
75213: AND h1.event_id = xet.event_id

Line 75511: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

75507: --
75508: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75509: --
75510:
75511: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75512: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

75509: --
75510:
75511: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75512: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

75512: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:

Line 75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 75600: , AR_TRANSACTIONS_S_V h5

75596: , h5.TRX_DOC_SEQUENCE_ID source_82
75597: FROM xla_events_gt xet
75598: , AR_BILL_TO_CUSTOMERS_S_V h1
75599: , AR_BILL_TO_SITE_USES_S_V h2
75600: , AR_TRANSACTIONS_S_V h5
75601: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75602: and xet.event_class_code = C_EVENT_CLASS_CODE
75603: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
75604: AND h2.event_id = h1.event_id

Line 78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

78714: FROM (
78715: SELECT xet.event_id event_id
78716: , l5.line_number line_number
78717: , CASE r
78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

78715: SELECT xet.event_id event_id
78716: , l5.line_number line_number
78717: , CASE r
78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

78716: , l5.line_number line_number
78717: , CASE r
78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'

Line 78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'

78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'
78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'

78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78935: , AR_TRANSACTIONS_S_V l10

78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10
78936: , FV_XLA_AR_REF_V l11
78937: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
78938: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78939: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;

Line 79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79325: , AR_TRANSACTIONS_S_V l10

79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7
79325: , AR_TRANSACTIONS_S_V l10
79326: , FV_XLA_AR_REF_V l11
79327: WHERE xet.event_id between x_first_event_id and x_last_event_id
79328: and xet.event_date between p_pad_start_date and p_pad_end_date
79329: and xet.event_class_code = C_EVENT_CLASS_CODE