DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 803: -- first get the sub and loc from wip_requirement_operations_v

799: -- 1. First try to get staging sub/loc from the job
800: -- 2. If can't find from job for a pull job, get from wip parameter
801: --}}
802: BEGIN
803: -- first get the sub and loc from wip_requirement_operations_v
804:
805: SELECT nvl(nvl(supply_subinventory, mp.default_crossdock_subinventory), wp.default_pull_supply_subinv),
806: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
807: INTO l_to_sub_code,

Line 809: FROM wip_requirement_operations wro,

805: SELECT nvl(nvl(supply_subinventory, mp.default_crossdock_subinventory), wp.default_pull_supply_subinv),
806: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
807: INTO l_to_sub_code,
808: l_to_loc_id
809: FROM wip_requirement_operations wro,
810: mtl_txn_request_lines mtrl,
811: mtl_parameters mp,
812: wip_parameters wp
813: WHERE wro.organization_id = l_org_id