DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000005_PKG dependencies on AR_BILL_TO_CUSTOMERS_S_V

Line 66739: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

66735: SELECT xet.event_id event_id
66736: , 0 line_number
66737: , CASE r
66738: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66739: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66740: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
66741: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
66742: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'
66743: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'

Line 66796: , AR_BILL_TO_CUSTOMERS_S_V h2

66792: END source_value
66793: , null source_meaning
66794: FROM xla_events_gt xet
66795: , AR_ADJUSTMENTS_H_V h1
66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66799: , AR_TRANSACTIONS_S_V h7
66800: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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

67084: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67085: --
67086:
67087: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
67088: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67089: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67090: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67091: TYPE t_array_source_77 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
67092: TYPE t_array_source_78 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 67163: , AR_BILL_TO_CUSTOMERS_S_V h2

67159: , h1.ADJ_DOC_SEQUENCE_ID source_78
67160: , h1.ADJ_DOC_SEQUENCE_VALUE source_79
67161: FROM xla_events_gt xet
67162: , AR_ADJUSTMENTS_H_V h1
67163: , AR_BILL_TO_CUSTOMERS_S_V h2
67164: , AR_BILL_TO_SITE_USES_S_V h3
67165: , AR_RECEIVABLES_TRX_ACT_S_V h6
67166: , AR_TRANSACTIONS_S_V h7
67167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 68246: , AR_BILL_TO_CUSTOMERS_S_V h1

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

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

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

Line 68602: , AR_BILL_TO_CUSTOMERS_S_V h1

68598: , h5.TRX_INVOICE_CURRENCY_CODE source_37
68599: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
68600: , h5.TRX_DOC_SEQUENCE_ID source_82
68601: FROM xla_events_gt xet
68602: , AR_BILL_TO_CUSTOMERS_S_V h1
68603: , AR_BILL_TO_SITE_USES_S_V h2
68604: , AR_TRANSACTIONS_S_V h5
68605: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68606: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 71224: , AR_BILL_TO_CUSTOMERS_S_V h1

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

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

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

Line 71587: , AR_BILL_TO_CUSTOMERS_S_V h1

71583: , h5.TRX_INVOICE_CURRENCY_CODE source_37
71584: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
71585: , h5.TRX_DOC_SEQUENCE_ID source_82
71586: FROM xla_events_gt xet
71587: , AR_BILL_TO_CUSTOMERS_S_V h1
71588: , AR_BILL_TO_SITE_USES_S_V h2
71589: , AR_TRANSACTIONS_S_V h5
71590: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71591: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 72705: , AR_BILL_TO_CUSTOMERS_S_V h1

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

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

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

Line 73061: , AR_BILL_TO_CUSTOMERS_S_V h1

73057: , h5.TRX_INVOICE_CURRENCY_CODE source_37
73058: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
73059: , h5.TRX_DOC_SEQUENCE_ID source_82
73060: FROM xla_events_gt xet
73061: , AR_BILL_TO_CUSTOMERS_S_V h1
73062: , AR_BILL_TO_SITE_USES_S_V h2
73063: , AR_TRANSACTIONS_S_V h5
73064: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73065: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 73951: , AR_BILL_TO_CUSTOMERS_S_V h1

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

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

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

Line 74307: , AR_BILL_TO_CUSTOMERS_S_V h1

74303: , h5.TRX_INVOICE_CURRENCY_CODE source_37
74304: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
74305: , h5.TRX_DOC_SEQUENCE_ID source_82
74306: FROM xla_events_gt xet
74307: , AR_BILL_TO_CUSTOMERS_S_V h1
74308: , AR_BILL_TO_SITE_USES_S_V h2
74309: , AR_TRANSACTIONS_S_V h5
74310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74311: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75141: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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

Line 75207: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 75512: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

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

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

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

Line 75598: , AR_BILL_TO_CUSTOMERS_S_V h1

75594: , h5.TRX_INVOICE_CURRENCY_CODE source_37
75595: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
75596: , h5.TRX_DOC_SEQUENCE_ID source_82
75597: FROM xla_events_gt xet
75598: , AR_BILL_TO_CUSTOMERS_S_V h1
75599: , AR_BILL_TO_SITE_USES_S_V h2
75600: , AR_TRANSACTIONS_S_V h5
75601: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75602: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'

Line 78930: , AR_BILL_TO_CUSTOMERS_S_V l1

78926: ELSE null
78927: END source_value
78928: , null source_meaning
78929: FROM xla_events_gt xet
78930: , AR_BILL_TO_CUSTOMERS_S_V l1
78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7

Line 79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 79320: , AR_BILL_TO_CUSTOMERS_S_V l1

79316: , l4.DIST_ACCTD_AMT source_69
79317: , l4.DIST_TO_CUR_CONVERSION_TYPE source_70
79318: , l5.DIST_SOURCE_TABLE source_71
79319: FROM xla_events_gt xet
79320: , AR_BILL_TO_CUSTOMERS_S_V l1
79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7