DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

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

567: -- 1. First try to get staging sub/loc from the job
568: -- 2. If can't find from job for a pull job, get from wip parameter
569: --}}
570: BEGIN
571: -- first get the sub and loc from wip_requirement_operations_v
572:
573: SELECT nvl(nvl(supply_subinventory, mp.default_crossdock_subinventory), wp.default_pull_supply_subinv),
574: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
575: INTO l_to_sub_code,

Line 577: FROM wip_requirement_operations wro,

573: SELECT nvl(nvl(supply_subinventory, mp.default_crossdock_subinventory), wp.default_pull_supply_subinv),
574: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
575: INTO l_to_sub_code,
576: l_to_loc_id
577: FROM wip_requirement_operations wro,
578: mtl_txn_request_lines mtrl,
579: mtl_parameters mp,
580: wip_parameters wp
581: WHERE wro.organization_id = l_org_id