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.

VIEW: APPS.WMS_STAGINGLANES_ASSIGNMENTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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