VIEW: APPS.CSD_REPAIR_ACTUALS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)