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_000009_PKG dependencies on AR_BILL_TO_CUSTOMERS_S_V

Line 67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

67697: , 0 line_number
67698: , CASE r
67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
67704: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
67705: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 67762: , AR_BILL_TO_CUSTOMERS_S_V h2

67758: END source_value
67759: , null source_meaning
67760: FROM xla_events_gt xet
67761: , AR_ADJUSTMENTS_H_V h1
67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67765: , AR_TRANSACTIONS_S_V h7
67766: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

Line 68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

68051: --
68052:
68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68058: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68059: TYPE t_array_source_82 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68132: , AR_BILL_TO_CUSTOMERS_S_V h2

68128: , h1.ADJ_DOC_SEQUENCE_ID source_82
68129: , h1.ADJ_DOC_SEQUENCE_VALUE source_83
68130: FROM xla_events_gt xet
68131: , AR_ADJUSTMENTS_H_V h1
68132: , AR_BILL_TO_CUSTOMERS_S_V h2
68133: , AR_BILL_TO_SITE_USES_S_V h3
68134: , AR_RECEIVABLES_TRX_ACT_S_V h6
68135: , AR_TRANSACTIONS_S_V h7
68136: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

69065: FROM (
69066: SELECT xet.event_id event_id
69067: , 0 line_number
69068: , CASE r
69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 69126: , AR_BILL_TO_CUSTOMERS_S_V h1

69122: ELSE null
69123: END source_value
69124: , null source_meaning
69125: FROM xla_events_gt xet
69126: , AR_BILL_TO_CUSTOMERS_S_V h1
69127: , AR_BILL_TO_SITE_USES_S_V h2
69128: , AR_TRANSACTIONS_S_V h5
69129: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
69130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

69405: --
69406: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69407: --
69408:
69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 69482: , AR_BILL_TO_CUSTOMERS_S_V h1

69478: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
69479: , h5.TRX_DOC_SEQUENCE_ID source_86
69480: , h5.TRX_DOC_SEQUENCE_VALUE source_87
69481: FROM xla_events_gt xet
69482: , AR_BILL_TO_CUSTOMERS_S_V h1
69483: , AR_BILL_TO_SITE_USES_S_V h2
69484: , AR_TRANSACTIONS_S_V h5
69485: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69486: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

71931: SELECT xet.event_id event_id
71932: , 0 line_number
71933: , CASE r
71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 72001: , AR_BILL_TO_CUSTOMERS_S_V h1

71997: ELSE null
71998: END source_value
71999: , null source_meaning
72000: FROM xla_events_gt xet
72001: , AR_BILL_TO_CUSTOMERS_S_V h1
72002: , AR_BILL_TO_SITE_USES_S_V h2
72003: , AR_TRANSACTIONS_S_V h5
72004: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72005: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

72286: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72287: --
72288:
72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72370: , AR_BILL_TO_CUSTOMERS_S_V h1

72366: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
72367: , h5.TRX_DOC_SEQUENCE_ID source_86
72368: , h5.TRX_DOC_SEQUENCE_VALUE source_87
72369: FROM xla_events_gt xet
72370: , AR_BILL_TO_CUSTOMERS_S_V h1
72371: , AR_BILL_TO_SITE_USES_S_V h2
72372: , AR_TRANSACTIONS_S_V h5
72373: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72374: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

73401: FROM (
73402: SELECT xet.event_id event_id
73403: , 0 line_number
73404: , CASE r
73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 73462: , AR_BILL_TO_CUSTOMERS_S_V h1

73458: ELSE null
73459: END source_value
73460: , null source_meaning
73461: FROM xla_events_gt xet
73462: , AR_BILL_TO_CUSTOMERS_S_V h1
73463: , AR_BILL_TO_SITE_USES_S_V h2
73464: , AR_TRANSACTIONS_S_V h5
73465: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73466: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

73741: --
73742: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73743: --
73744:
73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 73818: , AR_BILL_TO_CUSTOMERS_S_V h1

73814: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
73815: , h5.TRX_DOC_SEQUENCE_ID source_86
73816: , h5.TRX_DOC_SEQUENCE_VALUE source_87
73817: FROM xla_events_gt xet
73818: , AR_BILL_TO_CUSTOMERS_S_V h1
73819: , AR_BILL_TO_SITE_USES_S_V h2
73820: , AR_TRANSACTIONS_S_V h5
73821: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73822: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

74647: FROM (
74648: SELECT xet.event_id event_id
74649: , 0 line_number
74650: , CASE r
74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 74708: , AR_BILL_TO_CUSTOMERS_S_V h1

74704: ELSE null
74705: END source_value
74706: , null source_meaning
74707: FROM xla_events_gt xet
74708: , AR_BILL_TO_CUSTOMERS_S_V h1
74709: , AR_BILL_TO_SITE_USES_S_V h2
74710: , AR_TRANSACTIONS_S_V h5
74711: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

74987: --
74988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74989: --
74990:
74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 75064: , AR_BILL_TO_CUSTOMERS_S_V h1

75060: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
75061: , h5.TRX_DOC_SEQUENCE_ID source_86
75062: , h5.TRX_DOC_SEQUENCE_VALUE source_87
75063: FROM xla_events_gt xet
75064: , AR_BILL_TO_CUSTOMERS_S_V h1
75065: , AR_BILL_TO_SITE_USES_S_V h2
75066: , AR_TRANSACTIONS_S_V h5
75067: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75068: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

75894: SELECT xet.event_id event_id
75895: , 0 line_number
75896: , CASE r
75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

75895: , 0 line_number
75896: , CASE r
75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 75969: , AR_BILL_TO_CUSTOMERS_S_V h1

75965: ELSE null
75966: END source_value
75967: , null source_meaning
75968: FROM xla_events_gt xet
75969: , AR_BILL_TO_CUSTOMERS_S_V h1
75970: , AR_BILL_TO_SITE_USES_S_V h2
75971: , AR_TRANSACTIONS_S_V h5
75972: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
75973: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

76270: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76271: --
76272:
76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

76271: --
76272:
76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76363: , AR_BILL_TO_CUSTOMERS_S_V h1

76359: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
76360: , h5.TRX_DOC_SEQUENCE_ID source_86
76361: , h5.TRX_DOC_SEQUENCE_VALUE source_87
76362: FROM xla_events_gt xet
76363: , AR_BILL_TO_CUSTOMERS_S_V h1
76364: , AR_BILL_TO_SITE_USES_S_V h2
76365: , AR_TRANSACTIONS_S_V h5
76366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76367: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

79512: SELECT xet.event_id event_id
79513: , l5.line_number line_number
79514: , CASE r
79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_V'
79518: WHEN 4 THEN 'FV_XLA_AR_REF_V'
79519: WHEN 5 THEN 'FV_XLA_AR_REF_V'
79520: WHEN 6 THEN 'FV_XLA_AR_REF_V'

Line 79712: , AR_BILL_TO_CUSTOMERS_S_V l1

79708: ELSE null
79709: END source_value
79710: , null source_meaning
79711: FROM xla_events_gt xet
79712: , AR_BILL_TO_CUSTOMERS_S_V l1
79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8

Line 79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79889: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79890: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79891: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 80110: , AR_BILL_TO_CUSTOMERS_S_V l1

80106: , l4.DIST_ACCTD_AMT source_75
80107: , l4.DIST_TO_CUR_CONVERSION_TYPE source_76
80108: , l5.DIST_SOURCE_TABLE source_77
80109: FROM xla_events_gt xet
80110: , AR_BILL_TO_CUSTOMERS_S_V l1
80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
80114: , AR_RECEIVABLES_TRX_ACT_S_V l8