Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_LOCATION_VALUES_V |
SELECT ARLV.ROWID ROW_ID
, ARLV.LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, ARLV.LOCATION_SEGMENT_USER_VALUE LOCATION_SEGMENT_USER_VALUE
, ARLV.LOCATION_STRUCTURE_ID LOCATION_STRUCTURE_ID
, ARLV.LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_QUALIFIER
, ARLV.LOCATION_SEGMENT_VALUE LOCATION_SEGMENT_VALUE
, ARLV.LOCATION_SEGMENT_DESCRIPTION LOCATION_SEGMENT_DESCRIPTION
, ARLV.PARENT_SEGMENT_ID PARENT_SEGMENT_ID
, ARLVA.LOCATION_VALUE_ACCOUNT_ID LOCATION_VALUE_ACCOUNT_ID
, ARLVA.TAX_ACCOUNT_CCID TAX_ACCOUNT_CCID
, ARLVA.INTERIM_TAX_CCID INTERIM_TAX_CCID
, ARLVA.ADJ_CCID ADJ_CCID
, ARLVA.EDISC_CCID EDISC_CCID
, ARLVA.UNEDISC_CCID UNEDISC_CCID
, ARLVA.FINCHRG_CCID FINCHRG_CCID
, ARLVA.ADJ_NON_REC_TAX_CCID ADJ_NON_REC_TAX_CCID
, ARLVA.EDISC_NON_REC_TAX_CCID EDISC_NON_REC_TAX_CCID
, ARLVA.UNEDISC_NON_REC_TAX_CCID UNEDISC_NON_REC_TAX_CCID
, ARLVA.FINCHRG_NON_REC_TAX_CCID FINCHRG_NON_REC_TAX_CCID
, ARLV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ARLV.ATTRIBUTE1 ATTRIBUTE1
, ARLV.ATTRIBUTE2 ATTRIBUTE2
, ARLV.ATTRIBUTE3 ATTRIBUTE3
, ARLV.ATTRIBUTE4 ATTRIBUTE4
, ARLV.ATTRIBUTE5 ATTRIBUTE5
, ARLV.ATTRIBUTE6 ATTRIBUTE6
, ARLV.ATTRIBUTE7 ATTRIBUTE7
, ARLV.ATTRIBUTE8 ATTRIBUTE8
, ARLV.ATTRIBUTE9 ATTRIBUTE9
, ARLV.ATTRIBUTE10 ATTRIBUTE10
, ARLV.ATTRIBUTE11 ATTRIBUTE11
, ARLV.ATTRIBUTE12 ATTRIBUTE12
, ARLV.ATTRIBUTE13 ATTRIBUTE13
, ARLV.ATTRIBUTE14 ATTRIBUTE14
, ARLV.ATTRIBUTE15 ATTRIBUTE15
, ARLVA.CREATED_BY CREATED_BY
, ARLVA.CREATION_DATE CREATION_DATE
, ARLVA.LAST_UPDATED_BY LAST_UPDATED_BY
, ARLVA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARLVA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ARLVA.REQUEST_ID REQUEST_ID
, ARLVA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ARLVA.PROGRAM_ID PROGRAM_ID
, ARLVA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM AR_LOCATION_VALUES_OLD ARLV
, AR_LOCATION_ACCOUNTS ARLVA
WHERE ARLV.LOCATION_SEGMENT_ID = ARLVA.LOCATION_SEGMENT_ID(+)