YMS Yard Equipment Move Slip

Description
Categories: BI Publisher
Application: Oracle Yard Management
Source: Yard Equipment Move Slip (XML)
Short Name: YMSTOPKL_XML
DB package: YMS_YMSTOPKL_XMLP_PKG
SELECT yedv.TRAILER_SCAC_CODE SCAC
   			      , yedv.EQUIPMENT_NUMBER EQUIP_NUMBER
			      , yedv.REQUEST_NUMBER REQ_NUMBER
			      , yedv.INVENTORY_ITEM_ID ITEM_ID
			      , yedv.CURRENT_SUBINVENTORY_CODE FROM_SUBINV
			      , yedv.CURRENT_LOCATOR_ALIAS FROM_LOCATOR
			      , yedv.TRANSFER_SUBINVENTORY TO_SUBINV
			      , yedv.TRANSFER_LOCATOR_ALIAS TO_LOCATOR
			      , yedv.USER_NAME USER_NAME
  			 FROM yms_equipment_details_v yedv
                            , MTL_TXN_REQUEST_LINES MTRL
                        WHERE yedv.HEADER_ID = MTRL.HEADER_ID
                          AND MTRL.ORGANIZATION_ID = :P_ORG_ID
			  and &P_WHERE
Parameter Name SQL text Validation
Yard
 
LOV Oracle
Move Order Number From
 
LOV Oracle
Move Order Number To
 
LOV Oracle
Source Yard Area
 
LOV Oracle
Source Parking Spot
 
LOV Oracle
Destination Yard Area
 
LOV Oracle
Destination Parking Spot
 
LOV Oracle
Date Required From
 
Date
Date Required To
 
Date
SCAC
 
LOV Oracle
Equipment Number
 
LOV Oracle
Assigned user
 
LOV Oracle