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_BILL_TO_CUSTOMERS_S_V

Line 68911: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
68914: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
68915: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 68972: , AR_BILL_TO_CUSTOMERS_S_V h2

68968: END source_value
68969: , null source_meaning
68970: FROM xla_events_gt xet
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)

Line 69265: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%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;
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;

Line 69342: , AR_BILL_TO_CUSTOMERS_S_V h2

69338: , h1.ADJ_DOC_SEQUENCE_ID source_80
69339: , h1.ADJ_DOC_SEQUENCE_VALUE source_81
69340: FROM xla_events_gt xet
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

Line 70310: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

70306: FROM (
70307: SELECT xet.event_id event_id
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'

Line 70367: , AR_BILL_TO_CUSTOMERS_S_V h1

70363: ELSE null
70364: END source_value
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

Line 70650: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

70646: --
70647: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 70723: , AR_BILL_TO_CUSTOMERS_S_V h1

70719: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
70720: , h5.TRX_DOC_SEQUENCE_ID source_84
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

Line 73176: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
73180: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 73242: , AR_BILL_TO_CUSTOMERS_S_V h1

73238: ELSE null
73239: END source_value
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

Line 73531: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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;
73535: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73611: , AR_BILL_TO_CUSTOMERS_S_V h1

73607: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
73608: , h5.TRX_DOC_SEQUENCE_ID source_84
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

Line 74646: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

74642: FROM (
74643: SELECT xet.event_id event_id
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'

Line 74703: , AR_BILL_TO_CUSTOMERS_S_V h1

74699: ELSE null
74700: END source_value
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

Line 74986: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

74982: --
74983: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 75059: , AR_BILL_TO_CUSTOMERS_S_V h1

75055: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
75056: , h5.TRX_DOC_SEQUENCE_ID source_84
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

Line 75892: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

75888: FROM (
75889: SELECT xet.event_id event_id
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'

Line 75949: , AR_BILL_TO_CUSTOMERS_S_V h1

75945: ELSE null
75946: END source_value
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

Line 76232: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

76228: --
76229: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 76305: , AR_BILL_TO_CUSTOMERS_S_V h1

76301: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
76302: , h5.TRX_DOC_SEQUENCE_ID source_84
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

Line 77138: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

77134: FROM (
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'

Line 77140: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
77144: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 77210: , AR_BILL_TO_CUSTOMERS_S_V h1

77206: ELSE null
77207: END source_value
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

Line 77514: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

77510: --
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;

Line 77516: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%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;
77520: TYPE t_array_source_68 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77604: , AR_BILL_TO_CUSTOMERS_S_V h1

77600: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
77601: , h5.TRX_DOC_SEQUENCE_ID source_84
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

Line 80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

80754: , l5.line_number line_number
80755: , CASE r
80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'

Line 80953: , AR_BILL_TO_CUSTOMERS_S_V l1

80949: ELSE null
80950: END source_value
80951: , null source_meaning
80952: FROM xla_events_gt xet
80953: , AR_BILL_TO_CUSTOMERS_S_V l1
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

Line 81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 81345: , AR_BILL_TO_CUSTOMERS_S_V l1

81341: , l4.DIST_ACCTD_AMT source_73
81342: , l4.DIST_TO_CUR_CONVERSION_TYPE source_74
81343: , l5.DIST_SOURCE_TABLE source_75
81344: FROM xla_events_gt xet
81345: , AR_BILL_TO_CUSTOMERS_S_V l1
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