DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000002_PKG dependencies on AR_ADJUSTMENTS_H_V

Line 66546: WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'

66542: FROM (
66543: SELECT xet.event_id event_id
66544: , 0 line_number
66545: , CASE r
66546: WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'
66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'

66543: SELECT xet.event_id event_id
66544: , 0 line_number
66545: , CASE r
66546: WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'
66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
66553: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
66554:
66555: ELSE null
66556: END object_name

Line 66553: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'

66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
66553: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
66554:
66555: ELSE null
66556: END object_name
66557: , CASE r

Line 66608: , AR_ADJUSTMENTS_H_V h1

66604: ELSE null
66605: END source_value
66606: , null source_meaning
66607: FROM xla_events_gt xet
66608: , AR_ADJUSTMENTS_H_V h1
66609: , AR_BILL_TO_CUSTOMERS_S_V h2
66610: , AR_BILL_TO_SITE_USES_S_V h3
66611: , AR_RECEIVABLES_TRX_ACT_S_V h6
66612: , AR_TRANSACTIONS_S_V h7

Line 66900: TYPE t_array_source_1 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_NUMBER%TYPE INDEX BY BINARY_INTEGER;

66896: --
66897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66898: --
66899:
66900: TYPE t_array_source_1 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

66897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66898: --
66899:
66900: TYPE t_array_source_1 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66978: , AR_ADJUSTMENTS_H_V h1

66974: , h7.XLA_PARTY_TYPE source_51
66975: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_117
66976: , h1.ADJ_DOC_SEQUENCE_ID source_118
66977: FROM xla_events_gt xet
66978: , AR_ADJUSTMENTS_H_V h1
66979: , AR_BILL_TO_CUSTOMERS_S_V h2
66980: , AR_BILL_TO_SITE_USES_S_V h3
66981: , AR_RECEIVABLES_TRX_ACT_S_V h6
66982: , AR_TRANSACTIONS_S_V h7