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