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
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 |