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

Line 53083: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

53079: FROM (
53080: SELECT xet.event_id event_id
53081: , 0 line_number
53082: , CASE r
53083: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
53084: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
53085: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
53086: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
53087: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 53087: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

53083: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
53084: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
53085: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
53086: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
53087: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
53088: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
53089: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
53090: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
53091:

Line 53149: , AR_TRANSACTIONS_S_V h7

53145: , AR_ADJUSTMENTS_H_V h1
53146: , AR_BILL_TO_CUSTOMERS_S_V h2
53147: , AR_BILL_TO_SITE_USES_S_V h3
53148: , AR_RECEIVABLES_TRX_ACT_S_V h6
53149: , AR_TRANSACTIONS_S_V h7
53150: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
53151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53152: AND xet.event_class_code = C_EVENT_CLASS_CODE
53153: AND h1.event_id = xet.event_id

Line 53437: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

53433: --
53434: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53435: --
53436:
53437: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53438: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53439: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53440: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53441: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53441: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

53437: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53438: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53439: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53440: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53441: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53442: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53443: TYPE t_array_source_74 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53444: TYPE t_array_source_75 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53445:

Line 53519: , AR_TRANSACTIONS_S_V h7

53515: , AR_ADJUSTMENTS_H_V h1
53516: , AR_BILL_TO_CUSTOMERS_S_V h2
53517: , AR_BILL_TO_SITE_USES_S_V h3
53518: , AR_RECEIVABLES_TRX_ACT_S_V h6
53519: , AR_TRANSACTIONS_S_V h7
53520: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53521: and xet.event_class_code = C_EVENT_CLASS_CODE
53522: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
53523: AND h2.event_id = h1.event_id

Line 54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

54451: , 0 line_number
54452: , CASE r
54453: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54454: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

54452: , CASE r
54453: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54454: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54460:

Line 54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

54453: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54454: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54460:
54461: ELSE null

Line 54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

54454: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54460:
54461: ELSE null
54462: END object_name

Line 54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
54458: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
54459: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
54460:
54461: ELSE null
54462: END object_name
54463: , CASE r

Line 54512: , AR_TRANSACTIONS_S_V h5

54508: , null source_meaning
54509: FROM xla_events_gt xet
54510: , AR_BILL_TO_CUSTOMERS_S_V h1
54511: , AR_BILL_TO_SITE_USES_S_V h2
54512: , AR_TRANSACTIONS_S_V h5
54513: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54515: AND xet.event_class_code = C_EVENT_CLASS_CODE
54516: AND h1.event_id = xet.event_id

Line 54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

54791: --
54792:
54793: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54794: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

54792:
54793: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54794: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:

Line 54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

54793: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54794: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

54794: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 54868: , AR_TRANSACTIONS_S_V h5

54864: , h5.TRX_DOC_SEQUENCE_VALUE source_79
54865: FROM xla_events_gt xet
54866: , AR_BILL_TO_CUSTOMERS_S_V h1
54867: , AR_BILL_TO_SITE_USES_S_V h2
54868: , AR_TRANSACTIONS_S_V h5
54869: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54870: and xet.event_class_code = C_EVENT_CLASS_CODE
54871: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
54872: AND h2.event_id = h1.event_id

Line 57318: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

57314: FROM (
57315: SELECT xet.event_id event_id
57316: , 0 line_number
57317: , CASE r
57318: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

57317: , CASE r
57318: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

57318: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57327:

Line 57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57327:
57328: ELSE null

Line 57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57327:
57328: ELSE null
57329: END object_name

Line 57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
57324: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
57325: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
57326: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
57327:
57328: ELSE null
57329: END object_name
57330: , CASE r

Line 57387: , AR_TRANSACTIONS_S_V h5

57383: , null source_meaning
57384: FROM xla_events_gt xet
57385: , AR_BILL_TO_CUSTOMERS_S_V h1
57386: , AR_BILL_TO_SITE_USES_S_V h2
57387: , AR_TRANSACTIONS_S_V h5
57388: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57389: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57390: AND xet.event_class_code = C_EVENT_CLASS_CODE
57391: AND h1.event_id = xet.event_id

Line 57673: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

57669: --
57670: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57671: --
57672:
57673: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

57672:
57673: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

57673: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:

Line 57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57756: , AR_TRANSACTIONS_S_V h5

57752: , h5.TRX_DOC_SEQUENCE_VALUE source_79
57753: FROM xla_events_gt xet
57754: , AR_BILL_TO_CUSTOMERS_S_V h1
57755: , AR_BILL_TO_SITE_USES_S_V h2
57756: , AR_TRANSACTIONS_S_V h5
57757: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57758: and xet.event_class_code = C_EVENT_CLASS_CODE
57759: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
57760: AND h2.event_id = h1.event_id

Line 58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

58787: , 0 line_number
58788: , CASE r
58789: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58790: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

58788: , CASE r
58789: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58790: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58796:

Line 58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

58789: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58790: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58796:
58797: ELSE null

Line 58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

58790: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58796:
58797: ELSE null
58798: END object_name

Line 58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
58794: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
58795: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
58796:
58797: ELSE null
58798: END object_name
58799: , CASE r

Line 58848: , AR_TRANSACTIONS_S_V h5

58844: , null source_meaning
58845: FROM xla_events_gt xet
58846: , AR_BILL_TO_CUSTOMERS_S_V h1
58847: , AR_BILL_TO_SITE_USES_S_V h2
58848: , AR_TRANSACTIONS_S_V h5
58849: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58851: AND xet.event_class_code = C_EVENT_CLASS_CODE
58852: AND h1.event_id = xet.event_id

Line 59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

59127: --
59128:
59129: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
59130: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

59128:
59129: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
59130: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:

Line 59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

59129: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
59130: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

59130: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 59204: , AR_TRANSACTIONS_S_V h5

59200: , h5.TRX_DOC_SEQUENCE_VALUE source_79
59201: FROM xla_events_gt xet
59202: , AR_BILL_TO_CUSTOMERS_S_V h1
59203: , AR_BILL_TO_SITE_USES_S_V h2
59204: , AR_TRANSACTIONS_S_V h5
59205: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59206: and xet.event_class_code = C_EVENT_CLASS_CODE
59207: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
59208: AND h2.event_id = h1.event_id

Line 60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

60033: , 0 line_number
60034: , CASE r
60035: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
60036: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

60034: , CASE r
60035: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
60036: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
60042:

Line 60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

60035: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
60036: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
60042:
60043: ELSE null

Line 60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

60036: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
60042:
60043: ELSE null
60044: END object_name

Line 60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
60040: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
60041: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
60042:
60043: ELSE null
60044: END object_name
60045: , CASE r

Line 60094: , AR_TRANSACTIONS_S_V h5

60090: , null source_meaning
60091: FROM xla_events_gt xet
60092: , AR_BILL_TO_CUSTOMERS_S_V h1
60093: , AR_BILL_TO_SITE_USES_S_V h2
60094: , AR_TRANSACTIONS_S_V h5
60095: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
60096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60097: AND xet.event_class_code = C_EVENT_CLASS_CODE
60098: AND h1.event_id = xet.event_id

Line 60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

60373: --
60374:
60375: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60376: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

60374:
60375: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60376: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:

Line 60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

60375: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60376: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

60376: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 60450: , AR_TRANSACTIONS_S_V h5

60446: , h5.TRX_DOC_SEQUENCE_VALUE source_79
60447: FROM xla_events_gt xet
60448: , AR_BILL_TO_CUSTOMERS_S_V h1
60449: , AR_BILL_TO_SITE_USES_S_V h2
60450: , AR_TRANSACTIONS_S_V h5
60451: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60452: and xet.event_class_code = C_EVENT_CLASS_CODE
60453: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
60454: AND h2.event_id = h1.event_id

Line 61281: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

61277: FROM (
61278: SELECT xet.event_id event_id
61279: , 0 line_number
61280: , CASE r
61281: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

61280: , CASE r
61281: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

61281: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61290:

Line 61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61290:
61291: ELSE null

Line 61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61290:
61291: ELSE null
61292: END object_name

Line 61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
61287: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
61288: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
61289: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
61290:
61291: ELSE null
61292: END object_name
61293: , CASE r

Line 61350: , AR_TRANSACTIONS_S_V h5

61346: , null source_meaning
61347: FROM xla_events_gt xet
61348: , AR_BILL_TO_CUSTOMERS_S_V h1
61349: , AR_BILL_TO_SITE_USES_S_V h2
61350: , AR_TRANSACTIONS_S_V h5
61351: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61353: AND xet.event_class_code = C_EVENT_CLASS_CODE
61354: AND h1.event_id = xet.event_id

Line 61641: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

61637: --
61638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61639: --
61640:
61641: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

61640:
61641: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

61641: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:

Line 61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61726: , AR_TRANSACTIONS_S_V h5

61722: , h5.TRX_DOC_SEQUENCE_VALUE source_79
61723: FROM xla_events_gt xet
61724: , AR_BILL_TO_CUSTOMERS_S_V h1
61725: , AR_BILL_TO_SITE_USES_S_V h2
61726: , AR_TRANSACTIONS_S_V h5
61727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61728: and xet.event_class_code = C_EVENT_CLASS_CODE
61729: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
61730: AND h2.event_id = h1.event_id

Line 64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'

64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'

64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64655: , AR_TRANSACTIONS_S_V l10

64651: , AR_CUST_TRX_LINES_L_V l2
64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64655: , AR_TRANSACTIONS_S_V l10
64656: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64658: AND xet.event_class_code = C_EVENT_CLASS_CODE
64659: AND l3.event_id = xet.event_id

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

64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

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

64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 65028: , AR_TRANSACTIONS_S_V l10

65024: , AR_CUST_TRX_LINES_L_V l2
65025: , AR_DISTRIBUTIONS_BASE_V l3
65026: , AR_DISTRIBUTIONS_L_V l4
65027: , AR_RECEIVABLES_TRX_ACT_S_V l7
65028: , AR_TRANSACTIONS_S_V l10
65029: WHERE xet.event_id between x_first_event_id and x_last_event_id
65030: and xet.event_date between p_pad_start_date and p_pad_end_date
65031: and xet.event_class_code = C_EVENT_CLASS_CODE
65032: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id