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

ParameterTypeList of values SQL
YardLOV Oracle
Move Order Number FromLOV Oracle
Move Order Number ToLOV Oracle
Source Yard AreaLOV Oracle
Source Parking SpotLOV Oracle
Destination Yard AreaLOV Oracle
Destination Parking SpotLOV Oracle
Date Required FromDate
Date Required ToDate
SCACLOV Oracle
Equipment NumberLOV Oracle
Assigned userLOV Oracle