View: RLM_CUST_ITEM_CUM_DETAILS_V

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

View Text

SELECT 'ADJUSTMENT' TXN_TYPE
, ADJ.CUM_KEY_ID
, NULL SHIP_FROM
, NULL SHIP_TO
, NULL DELIVER_TO
, NULL BILL_TO
, ADJ.TRANSACTION_DATE_TIME TXN_DATE
, ADJ.TRANSACTION_QTY TXN_QUANTITY
, CKEYS.CUST_UOM_CODE QUANTITY_UOM
, TO_NUMBER(NULL) SHIPMENT_NUMBER
, FUSER.USER_NAME LAST_ADJUSTED_BY
, NULL LAST_SHIPPED_BY
, ADJ.ADJUSTMENT_REASON
, ADJ.ADJUSTMENT_REFERENCE
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.ATTRIBUTE_CATEGORY
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, ADJ.TP_ATTRIBUTE_CATEGORY
, ADJ.TP_ATTRIBUTE1
, ADJ.TP_ATTRIBUTE2
, ADJ.TP_ATTRIBUTE3
, ADJ.TP_ATTRIBUTE4
, ADJ.TP_ATTRIBUTE5
, ADJ.TP_ATTRIBUTE6
, ADJ.TP_ATTRIBUTE7
, ADJ.TP_ATTRIBUTE8
, ADJ.TP_ATTRIBUTE9
, ADJ.TP_ATTRIBUTE10
, ADJ.TP_ATTRIBUTE11
, ADJ.TP_ATTRIBUTE12
, ADJ.TP_ATTRIBUTE13
, ADJ.TP_ATTRIBUTE14
, ADJ.TP_ATTRIBUTE15
, ADJ.LAST_UPDATE_LOGIN
, ADJ.REQUEST_ID
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, RLM_CUST_ITEM_CUM_KEYS CKEYS
, RLM_CUST_ITEM_CUM_ADJ ADJ
, FND_USER FUSER
WHERE ORG.ORGANIZATION_ID = CKEYS.SHIP_FROM_ORG_ID
AND CKEYS.CUM_KEY_ID = ADJ.CUM_KEY_ID
AND FUSER.USER_ID = ADJ.LAST_UPDATED_BY UNION SELECT 'SHIPMENT' TXN_TYPE
, LINES.VEH_CUS_ITEM_CUM_KEY_ID
, ORG.ORGANIZATION_CODE SHIP_FROM
, STO.LOCATION SHIP_TO
, DELTO.LOCATION DELIVER_TO
, BILLTO.LOCATION BILL_TO
, LINES.ACTUAL_SHIPMENT_DATE TXN_DATE
, LINES.SHIPPED_QUANTITY TXN_QUANTITY
, LINES.SHIPPING_QUANTITY_UOM QUANTITY_UOM
, LINES.SHIPMENT_NUMBER
, NULL LAST_ADJUSTED_BY
, FUSER.USER_NAME LAST_SHIPPED_BY
, NULL ADJUSTMENT_REASON
, NULL ADJUSTMENT_REFERENCE
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
, LINES.CREATION_DATE
, LINES.CREATED_BY
, NULL ATTRIBUTE_CATEGORY
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, NULL TP_ATTRIBUTE_CATEGORY
, NULL TP_ATTRIBUTE1
, NULL TP_ATTRIBUTE2
, NULL TP_ATTRIBUTE3
, NULL TP_ATTRIBUTE4
, NULL TP_ATTRIBUTE5
, NULL TP_ATTRIBUTE6
, NULL TP_ATTRIBUTE7
, NULL TP_ATTRIBUTE8
, NULL TP_ATTRIBUTE9
, NULL TP_ATTRIBUTE10
, NULL TP_ATTRIBUTE11
, NULL TP_ATTRIBUTE12
, NULL TP_ATTRIBUTE13
, NULL TP_ATTRIBUTE14
, NULL TP_ATTRIBUTE15
, LINES.LAST_UPDATE_LOGIN
, LINES.REQUEST_ID
, LINES.PROGRAM_APPLICATION_ID
, LINES.PROGRAM_ID
, LINES.PROGRAM_UPDATE_DATE
FROM RA_SITE_USES STO
, RA_SITE_USES DELTO
, RA_SITE_USES BILLTO
, ORG_ORGANIZATION_DEFINITIONS ORG
, RLM_CUST_ITEM_CUM_KEYS CKEYS
, FND_USER FUSER
, OE_ORDER_LINES LINES
WHERE ORG.ORGANIZATION_ID = LINES.SHIP_FROM_ORG_ID
AND ORG.ORGANIZATION_ID = CKEYS.SHIP_FROM_ORG_ID
AND CKEYS.CUM_KEY_ID = LINES.VEH_CUS_ITEM_CUM_KEY_ID
AND STO.SITE_USE_ID = LINES.SHIP_TO_ORG_ID
AND DELTO.SITE_USE_ID(+) = LINES.DELIVER_TO_ORG_ID
AND BILLTO.SITE_USE_ID(+) = LINES.INVOICE_TO_ORG_ID
AND FUSER.USER_ID = LINES.LAST_UPDATED_BY

Columns