View: CSD_REPAIR_ACTUALS_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_REPAIR_ACTUALS_V

View Text

SELECT CRA.ROWID
, CRA.REPAIR_ACTUAL_ID
, CRA.OBJECT_VERSION_NUMBER
, CR.REPAIR_LINE_ID
, CR.REPAIR_NUMBER
, CRA.CREATED_BY
, CRA.CREATION_DATE
, CRA.LAST_UPDATED_BY
, CRA.LAST_UPDATE_DATE
, CRA.LAST_UPDATE_LOGIN
, CRA.ATTRIBUTE_CATEGORY
, CRA.ATTRIBUTE1
, CRA.ATTRIBUTE2
, CRA.ATTRIBUTE3
, CRA.ATTRIBUTE4
, CRA.ATTRIBUTE5
, CRA.ATTRIBUTE6
, CRA.ATTRIBUTE7
, CRA.ATTRIBUTE8
, CRA.ATTRIBUTE9
, CRA.ATTRIBUTE10
, CRA.ATTRIBUTE11
, CRA.ATTRIBUTE12
, CRA.ATTRIBUTE13
, CRA.ATTRIBUTE14
, CRA.ATTRIBUTE15
, CRA.BILL_TO_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, HCA.ACCOUNT_NAME
, CRA.BILL_TO_PARTY_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, CRA.BILL_TO_PARTY_SITE_ID
, SUBSTR(HL1.ADDRESS1||' '||HL1.ADDRESS2||' '||HL1.ADDRESS3||' '||HL1.ADDRESS4 ||' '|| HL1.CITY||' '||HL1.STATE||' '||HL1.COUNTRY||' '||HL1.POSTAL_CODE
, 1
, 440) BILL_TO_PARTY_SITE
FROM CSD_REPAIRS CR
, CSD_REPAIR_ACTUALS CRA
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HZ
, HZ_PARTY_SITES HP1
, HZ_LOCATIONS HL1
WHERE CR.REPAIR_LINE_ID = CRA.REPAIR_LINE_ID
AND HCA.CUST_ACCOUNT_ID (+) = CRA.BILL_TO_ACCOUNT_ID
AND HZ.PARTY_ID (+) = CRA.BILL_TO_PARTY_ID
AND HP1.PARTY_SITE_ID(+) = CRA.BILL_TO_PARTY_SITE_ID
AND HP1.LOCATION_ID = HL1.LOCATION_ID(+)

Columns