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
SQL 15 lines
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 |
Parameters 12
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |