Product: | RLM - Release Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RLM_CUM_SHIPFR_SHIPTO_V |
SELECT TERMS.ROWID ROW_ID
, SITE.ADDRESS_ID
, SITE.LOCATION
, TERMS.CUSTOMER_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, RAD.ECE_TP_LOCATION_CODE
, RAD.CUSTOMER_CATEGORY_CODE
, ORG.ORGANIZATION_CODE
, SITE.SITE_USE_ID
, SITE.SITE_USE_CODE
, TERMS.SHIP_FROM_ORG_ID
, TERMS.CUM_CONTROL_CODE
, TERMS.CUM_CONTROL_CODE CUM_CONTROL_CODE_MN
, TERMS.CUM_ORG_LEVEL_CODE
, TERMS.CUM_ORG_LEVEL_CODE CUM_ORG_LEVEL_CODE_MN
, TERMS.CUM_CURRENT_START_DATE
, TERMS.CUM_CURRENT_RECORD_YEAR
, TERMS.CUM_SHIPMENT_RULE_CODE
, TERMS.CUM_SHIPMENT_RULE_CODE CUM_SHIPMENT_RULE_CODE_MN
, TERMS.CUM_YESTERD_TIME_CUTOFF
, TERMS.LAST_UPDATE_DATE
, TERMS.LAST_UPDATED_BY
, TERMS.CREATION_DATE
, TERMS.CREATED_BY
, TERMS.ATTRIBUTE_CATEGORY
, TERMS.ATTRIBUTE1
, TERMS.ATTRIBUTE2
, TERMS.ATTRIBUTE3
, TERMS.ATTRIBUTE4
, TERMS.ATTRIBUTE5
, TERMS.ATTRIBUTE6
, TERMS.ATTRIBUTE7
, TERMS.ATTRIBUTE8
, TERMS.ATTRIBUTE9
, TERMS.ATTRIBUTE10
, TERMS.ATTRIBUTE11
, TERMS.ATTRIBUTE12
, TERMS.ATTRIBUTE13
, TERMS.ATTRIBUTE14
, TERMS.ATTRIBUTE15
, TERMS.TP_ATTRIBUTE_CATEGORY
, TERMS.TP_ATTRIBUTE1
, TERMS.TP_ATTRIBUTE2
, TERMS.TP_ATTRIBUTE3
, TERMS.TP_ATTRIBUTE4
, TERMS.TP_ATTRIBUTE5
, TERMS.TP_ATTRIBUTE6
, TERMS.TP_ATTRIBUTE7
, TERMS.TP_ATTRIBUTE8
, TERMS.TP_ATTRIBUTE9
, TERMS.TP_ATTRIBUTE10
, TERMS.TP_ATTRIBUTE11
, TERMS.TP_ATTRIBUTE12
, TERMS.TP_ATTRIBUTE13
, TERMS.TP_ATTRIBUTE14
, TERMS.TP_ATTRIBUTE15
, TERMS.LAST_UPDATE_LOGIN
, TERMS.REQUEST_ID
, TERMS.PROGRAM_APPLICATION_ID
, TERMS.PROGRAM_ID
, TERMS.PROGRAM_UPDATE_DATE
FROM RA_SITE_USES SITE
, RLM_CUST_SHIPTO_TERMS TERMS
, RA_ADDRESSES RAD
, RA_CUSTOMERS RAC
, ORG_ORGANIZATION_DEFINITIONS ORG
WHERE TERMS.CUSTOMER_ID = RAD.CUSTOMER_ID
AND RAD.CUSTOMER_ID = RAC.CUSTOMER_ID
AND RAD.ADDRESS_ID = SITE.ADDRESS_ID
AND RAC.CUSTOMER_ID = RAD.CUSTOMER_ID
AND SITE.SITE_USE_CODE = 'SHIP_TO'
AND (RAD.ADDRESS_ID = TERMS.ADDRESS_ID OR (TERMS.ADDRESS_ID IS NULL
AND NOT EXISTS (SELECT TT.ADDRESS_ID
FROM RLM_CUST_SHIPTO_TERMS TT
WHERE TT.CUSTOMER_ID = TERMS.CUSTOMER_ID
AND TT.SHIP_FROM_ORG_ID = TERMS.SHIP_FROM_ORG_ID
AND SITE.ADDRESS_ID = TT.ADDRESS_ID) ) )
AND ORG.ORGANIZATION_ID = TERMS.SHIP_FROM_ORG_ID
AND TERMS.CUM_CONTROL_CODE <> 'NO_CUM'