Product: | WMS - Warehouse Management |
---|---|
Description: | View based on the wms_staginglanes_assignments table. |
Implementation/DBA Data: | APPS.WMS_STAGINGLANES_ASSIGNMENTS_V |
SELECT STG.ROWID ROW_ID
, STG.DOCK_DOOR_ID
, STG.STAGE_LANE_ID
, STG.DOCK_DOOR_ORGANIZATION_ID
, STG.STAGING_LANE_ORGANIZATION_ID
, MTP.ORGANIZATION_CODE ORG_CODE
, STG.LAST_UPDATE_DATE
, STG.LAST_UPDATED_BY
, STG.CREATION_DATE
, STG.CREATED_BY
, STG.LAST_UPDATE_LOGIN
, STG.ENTRY_SEQUENCE
, STG.ENABLED
, MIL.CONCATENATED_SEGMENTS STAGING_LANE
, MIL.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MIL.INVENTORY_LOCATION_TYPE LOCATION_TYPE
, MIL.DESCRIPTION
, STG.ATTRIBUTE_CATEGORY
, STG.ATTRIBUTE1
, STG.ATTRIBUTE2
, STG.ATTRIBUTE3
, STG.ATTRIBUTE4
, STG.ATTRIBUTE5
, STG.ATTRIBUTE6
, STG.ATTRIBUTE7
, STG.ATTRIBUTE8
, STG.ATTRIBUTE9
, STG.ATTRIBUTE10
, STG.ATTRIBUTE11
, STG.ATTRIBUTE12
, STG.ATTRIBUTE13
, STG.ATTRIBUTE14
, STG.ATTRIBUTE15
FROM WMS_STAGINGLANES_ASSIGNMENTS STG
, MTL_ITEM_LOCATIONS_KFV MIL
, MTL_PARAMETERS MTP
WHERE STG.STAGE_LANE_ID = MIL.INVENTORY_LOCATION_ID
AND STG.STAGING_LANE_ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND STG.STAGING_LANE_ORGANIZATION_ID = MTP.ORGANIZATION_ID