eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: RLM_CUM_SHIPFR_SHIPTO_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	APPS.RLM_CUM_SHIPFR_SHIPTO_V

View Text

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'

Columns

Name
ROW_ID
ADDRESS_ID
LOCATION
CUSTOMER_ID
CUSTOMER_NAME
CUSTOMER_NUMBER
ECE_TP_LOCATION_CODE
CUSTOMER_CATEGORY_CODE
ORGANIZATION_CODE
SITE_USE_ID
SITE_USE_CODE
SHIP_FROM_ORG_ID
CUM_CONTROL_CODE
CUM_CONTROL_CODE_MN
CUM_ORG_LEVEL_CODE
CUM_ORG_LEVEL_CODE_MN
CUM_CURRENT_START_DATE
CUM_CURRENT_RECORD_YEAR
CUM_SHIPMENT_RULE_CODE
CUM_SHIPMENT_RULE_CODE_MN
CUM_YESTERD_TIME_CUTOFF
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
TP_ATTRIBUTE_CATEGORY
TP_ATTRIBUTE1
TP_ATTRIBUTE2
TP_ATTRIBUTE3
TP_ATTRIBUTE4
TP_ATTRIBUTE5
TP_ATTRIBUTE6
TP_ATTRIBUTE7
TP_ATTRIBUTE8
TP_ATTRIBUTE9
TP_ATTRIBUTE10
TP_ATTRIBUTE11
TP_ATTRIBUTE12
TP_ATTRIBUTE13
TP_ATTRIBUTE14
TP_ATTRIBUTE15
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE