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

Line 68909: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

68905: FROM (
68906: SELECT xet.event_id event_id
68907: , 0 line_number
68908: , CASE r
68909: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68910: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68911: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68912: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
68913: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 68913: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

68909: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68910: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68911: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68912: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
68913: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68914: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
68915: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
68916: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
68917:

Line 68975: , AR_TRANSACTIONS_S_V h7

68971: , AR_ADJUSTMENTS_H_V h1
68972: , AR_BILL_TO_CUSTOMERS_S_V h2
68973: , AR_BILL_TO_SITE_USES_S_V h3
68974: , AR_RECEIVABLES_TRX_ACT_S_V h6
68975: , AR_TRANSACTIONS_S_V h7
68976: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
68977: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68978: AND xet.event_class_code = C_EVENT_CLASS_CODE
68979: AND h1.event_id = xet.event_id

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

69259: --
69260: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69261: --
69262:
69263: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
69264: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69265: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69266: 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;
69267: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

69263: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
69264: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69265: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69266: 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;
69267: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69268: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69269: TYPE t_array_source_80 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69270: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69271:

Line 69345: , AR_TRANSACTIONS_S_V h7

69341: , AR_ADJUSTMENTS_H_V h1
69342: , AR_BILL_TO_CUSTOMERS_S_V h2
69343: , AR_BILL_TO_SITE_USES_S_V h3
69344: , AR_RECEIVABLES_TRX_ACT_S_V h6
69345: , AR_TRANSACTIONS_S_V h7
69346: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69347: and xet.event_class_code = C_EVENT_CLASS_CODE
69348: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
69349: AND h2.event_id = h1.event_id

Line 70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

70308: , 0 line_number
70309: , CASE r
70310: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70311: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

70309: , CASE r
70310: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70311: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70317:

Line 70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

70310: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70311: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70317:
70318: ELSE null

Line 70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

70311: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70317:
70318: ELSE null
70319: END object_name

Line 70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

70312: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
70313: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70314: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70315: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70316: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70317:
70318: ELSE null
70319: END object_name
70320: , CASE r

Line 70369: , AR_TRANSACTIONS_S_V h5

70365: , null source_meaning
70366: FROM xla_events_gt xet
70367: , AR_BILL_TO_CUSTOMERS_S_V h1
70368: , AR_BILL_TO_SITE_USES_S_V h2
70369: , AR_TRANSACTIONS_S_V h5
70370: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70372: AND xet.event_class_code = C_EVENT_CLASS_CODE
70373: AND h1.event_id = xet.event_id

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

70648: --
70649:
70650: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70651: 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;
70652: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70653: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

70649:
70650: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70651: 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;
70652: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70653: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:

Line 70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

70650: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70651: 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;
70652: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70653: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

70651: 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;
70652: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70653: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: 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 70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

70652: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70653: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70725: , AR_TRANSACTIONS_S_V h5

70721: , h5.TRX_DOC_SEQUENCE_VALUE source_85
70722: FROM xla_events_gt xet
70723: , AR_BILL_TO_CUSTOMERS_S_V h1
70724: , AR_BILL_TO_SITE_USES_S_V h2
70725: , AR_TRANSACTIONS_S_V h5
70726: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70727: and xet.event_class_code = C_EVENT_CLASS_CODE
70728: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
70729: AND h2.event_id = h1.event_id

Line 73175: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

73171: FROM (
73172: SELECT xet.event_id event_id
73173: , 0 line_number
73174: , CASE r
73175: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73176: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73177: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

73174: , CASE r
73175: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73176: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73177: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

73175: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73176: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73177: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

73176: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73177: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
73184:

Line 73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

73177: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
73184:
73185: ELSE null

Line 73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

73178: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
73184:
73185: ELSE null
73186: END object_name

Line 73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

73179: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73181: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73182: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
73183: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
73184:
73185: ELSE null
73186: END object_name
73187: , CASE r

Line 73244: , AR_TRANSACTIONS_S_V h5

73240: , null source_meaning
73241: FROM xla_events_gt xet
73242: , AR_BILL_TO_CUSTOMERS_S_V h1
73243: , AR_BILL_TO_SITE_USES_S_V h2
73244: , AR_TRANSACTIONS_S_V h5
73245: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73246: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73247: AND xet.event_class_code = C_EVENT_CLASS_CODE
73248: AND h1.event_id = xet.event_id

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

73526: --
73527: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73528: --
73529:
73530: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
73531: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73532: 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;
73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

73529:
73530: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
73531: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73532: 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;
73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

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

73530: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
73531: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73532: 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;
73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

73531: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73532: 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;
73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:

Line 73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

73532: 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;
73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

73533: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: 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 73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

73534: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73613: , AR_TRANSACTIONS_S_V h5

73609: , h5.TRX_DOC_SEQUENCE_VALUE source_85
73610: FROM xla_events_gt xet
73611: , AR_BILL_TO_CUSTOMERS_S_V h1
73612: , AR_BILL_TO_SITE_USES_S_V h2
73613: , AR_TRANSACTIONS_S_V h5
73614: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73615: and xet.event_class_code = C_EVENT_CLASS_CODE
73616: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
73617: AND h2.event_id = h1.event_id

Line 74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

74644: , 0 line_number
74645: , CASE r
74646: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74647: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

74645: , CASE r
74646: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74647: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74653:

Line 74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

74646: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74647: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74653:
74654: ELSE null

Line 74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

74647: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74653:
74654: ELSE null
74655: END object_name

Line 74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

74648: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74649: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74650: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74651: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74652: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74653:
74654: ELSE null
74655: END object_name
74656: , CASE r

Line 74705: , AR_TRANSACTIONS_S_V h5

74701: , null source_meaning
74702: FROM xla_events_gt xet
74703: , AR_BILL_TO_CUSTOMERS_S_V h1
74704: , AR_BILL_TO_SITE_USES_S_V h2
74705: , AR_TRANSACTIONS_S_V h5
74706: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74708: AND xet.event_class_code = C_EVENT_CLASS_CODE
74709: AND h1.event_id = xet.event_id

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

74984: --
74985:
74986: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74987: 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;
74988: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74989: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

74985:
74986: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74987: 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;
74988: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74989: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:

Line 74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

74986: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74987: 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;
74988: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74989: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

74987: 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;
74988: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74989: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: 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 74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

74988: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74989: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75061: , AR_TRANSACTIONS_S_V h5

75057: , h5.TRX_DOC_SEQUENCE_VALUE source_85
75058: FROM xla_events_gt xet
75059: , AR_BILL_TO_CUSTOMERS_S_V h1
75060: , AR_BILL_TO_SITE_USES_S_V h2
75061: , AR_TRANSACTIONS_S_V h5
75062: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75063: and xet.event_class_code = C_EVENT_CLASS_CODE
75064: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
75065: AND h2.event_id = h1.event_id

Line 75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

75890: , 0 line_number
75891: , CASE r
75892: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75893: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

75891: , CASE r
75892: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75893: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75899:

Line 75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

75892: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75893: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75899:
75900: ELSE null

Line 75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

75893: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75899:
75900: ELSE null
75901: END object_name

Line 75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

75894: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75895: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75896: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75897: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75899:
75900: ELSE null
75901: END object_name
75902: , CASE r

Line 75951: , AR_TRANSACTIONS_S_V h5

75947: , null source_meaning
75948: FROM xla_events_gt xet
75949: , AR_BILL_TO_CUSTOMERS_S_V h1
75950: , AR_BILL_TO_SITE_USES_S_V h2
75951: , AR_TRANSACTIONS_S_V h5
75952: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75954: AND xet.event_class_code = C_EVENT_CLASS_CODE
75955: AND h1.event_id = xet.event_id

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

76230: --
76231:
76232: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76233: 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;
76234: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76235: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

76231:
76232: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76233: 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;
76234: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76235: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:

Line 76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76232: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76233: 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;
76234: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76235: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

76233: 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;
76234: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76235: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: 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 76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

76234: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76235: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76307: , AR_TRANSACTIONS_S_V h5

76303: , h5.TRX_DOC_SEQUENCE_VALUE source_85
76304: FROM xla_events_gt xet
76305: , AR_BILL_TO_CUSTOMERS_S_V h1
76306: , AR_BILL_TO_SITE_USES_S_V h2
76307: , AR_TRANSACTIONS_S_V h5
76308: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76309: and xet.event_class_code = C_EVENT_CLASS_CODE
76310: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
76311: AND h2.event_id = h1.event_id

Line 77139: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

77135: SELECT xet.event_id event_id
77136: , 0 line_number
77137: , CASE r
77138: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77139: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
77140: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77141: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

77138: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77139: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
77140: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77141: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

77139: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
77140: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77141: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'

Line 77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

77140: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77141: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
77148:

Line 77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

77141: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
77148:
77149: ELSE null

Line 77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

77142: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
77148:
77149: ELSE null
77150: END object_name

Line 77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'

77143: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
77145: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
77146: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
77147: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
77148:
77149: ELSE null
77150: END object_name
77151: , CASE r

Line 77212: , AR_TRANSACTIONS_S_V h5

77208: , null source_meaning
77209: FROM xla_events_gt xet
77210: , AR_BILL_TO_CUSTOMERS_S_V h1
77211: , AR_BILL_TO_SITE_USES_S_V h2
77212: , AR_TRANSACTIONS_S_V h5
77213: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77214: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77215: AND xet.event_class_code = C_EVENT_CLASS_CODE
77216: AND h1.event_id = xet.event_id

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

77511: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77512: --
77513:
77514: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
77516: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
77517: 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;
77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

77514: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
77516: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
77517: 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;
77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

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

77515: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
77516: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
77517: 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;
77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

77516: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
77517: 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;
77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:

Line 77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77517: 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;
77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

77518: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

77519: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: 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 77606: , AR_TRANSACTIONS_S_V h5

77602: , h5.TRX_DOC_SEQUENCE_VALUE source_85
77603: FROM xla_events_gt xet
77604: , AR_BILL_TO_CUSTOMERS_S_V h1
77605: , AR_BILL_TO_SITE_USES_S_V h2
77606: , AR_TRANSACTIONS_S_V h5
77607: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77608: and xet.event_class_code = C_EVENT_CLASS_CODE
77609: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
77610: AND h2.event_id = h1.event_id

Line 80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'

80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'

80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80958: , AR_TRANSACTIONS_S_V l11

80954: , AR_CUST_TRX_LINES_L_V l3
80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11
80959: , FV_XLA_AR_REF_V l12
80960: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
80961: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80962: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

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

81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81350: , AR_TRANSACTIONS_S_V l11

81346: , AR_CUST_TRX_LINES_L_V l3
81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
81349: , AR_RECEIVABLES_TRX_ACT_S_V l8
81350: , AR_TRANSACTIONS_S_V l11
81351: , FV_XLA_AR_REF_V l12
81352: WHERE xet.event_id between x_first_event_id and x_last_event_id
81353: and xet.event_date between p_pad_start_date and p_pad_end_date
81354: and xet.event_class_code = C_EVENT_CLASS_CODE