Product: | RLM - Release Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RLM_CUM_SHIP_DETAILS_V |
SELECT LINES.VEH_CUS_ITEM_CUM_KEY_ID CUM_KEY_ID
, LINES.SHIP_FROM_ORG_ID
, LINES.SHIP_TO_ORG_ID
, LINES.INVOICE_TO_ORG_ID
, LINES.INTMED_SHIP_TO_ORG_ID
, LINES.INDUSTRY_ATTRIBUTE7 CUM_QUANTITY
, LINES.ACTUAL_SHIPMENT_DATE TXN_DATE
, LINES.SHIPPED_QUANTITY TXN_QUANTITY
, LINES.SHIPPING_QUANTITY_UOM QUANTITY_UOM
, LINES.SHIPMENT_NUMBER
, LINES.LINE_ID
, FUSER.USER_NAME LAST_SHIPPED_BY
, 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
, LINES.INVENTORY_ITEM_ID
FROM RLM_CUST_ITEM_CUM_KEYS CKEYS
, FND_USER FUSER
, OE_ORDER_LINES LINES
WHERE CKEYS.CUM_KEY_ID = LINES.VEH_CUS_ITEM_CUM_KEY_ID
AND FUSER.USER_ID = LINES.LAST_UPDATED_BY