DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WIP_PARAMETERS

Line 580: wip_parameters wp

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
582: AND mp.organization_id = l_org_id
583: AND wp.organization_id = l_org_id
584: AND mtrl.line_id = l_line_id

Line 601: -- if for pull job and if sub and loc is NULL, use wip_parameters

597:
598: GOTO loop_end;
599: END;
600:
601: -- if for pull job and if sub and loc is NULL, use wip_parameters
602: -- 9/30/05: Also do this for WIP push
603: IF (l_to_sub_code IS NULL OR l_to_loc_id IS NULL) THEN
604:
605: BEGIN

Line 610: FROM wip_parameters

606: SELECT default_pull_supply_subinv,
607: default_pull_supply_locator_id
608: INTO l_to_sub_code,
609: l_to_loc_id
610: FROM wip_parameters
611: WHERE organization_id = l_org_id;
612:
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN