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
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
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