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
Run YMS Yard Equipment Move Slip and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
WSH Shipping/Delivery Transactions WSH Pick Slip WSH Pick Slip Report PDF Output ONT Sales Order Workflow Status EAM Material Issue Request Pick List GL Account Analysis (Distributions) CSD Depot Repair XMLP Estimate ECC Sourcing, Negotiations, SQL1 ECC Enterprise Asset Management, Work Orders (Maintenance), SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: