YMS Yard Equipment Move Slip

➜ Back to Library
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 NameSQL textValidation
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
Download
Related Blitz Reports
WSH Pick Slip Report PDF Output WSH Pick Slip ONT Sales Order Workflow Status EAM Material Issue Request Pick List CSD Depot Repair XMLP Estimate ECC Enterprise Asset Management, Work Orders (Maintenance), SQL1 ECC Sourcing, Negotiations, SQL1 ECC Project Procurement, Procurement Plan EAM Work Orders
Blitz Report In Action
Blitz Report™