VIEW: APPS.RLM_CUM_SHIP_DETAILS_V

Source

View Text - Preformatted

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.ORDER_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, lines.ORG_ID FROM rlm_cust_item_cum_keys ckeys, fnd_user fuser, oe_order_lines_all lines WHERE ckeys.CUM_KEY_ID = lines.VEH_CUS_ITEM_CUM_KEY_ID AND fuser.user_id = lines.last_updated_by AND lines.ORG_ID = ckeys.ORG_ID

View Text - HTML Formatted

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.ORDER_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
, LINES.ORG_ID
FROM RLM_CUST_ITEM_CUM_KEYS CKEYS
, FND_USER FUSER
, OE_ORDER_LINES_ALL LINES
WHERE CKEYS.CUM_KEY_ID = LINES.VEH_CUS_ITEM_CUM_KEY_ID
AND FUSER.USER_ID = LINES.LAST_UPDATED_BY
AND LINES.ORG_ID = CKEYS.ORG_ID