[Home] [Help]
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
814: AND mp.organization_id = l_org_id
815: AND wp.organization_id = l_org_id
816: AND mtrl.line_id = l_line_id
829:
830: GOTO loop_end;
831: END;
832:
833: -- if for pull job and if sub and loc is NULL, use wip_parameters
834: -- 9/30/05: Also do this for WIP push
835: IF (l_to_sub_code IS NULL OR l_to_loc_id IS NULL) THEN
836:
837: BEGIN
838: SELECT default_pull_supply_subinv,
839: default_pull_supply_locator_id
840: INTO l_to_sub_code,
841: l_to_loc_id
842: FROM wip_parameters
843: WHERE organization_id = l_org_id;
844:
845: EXCEPTION
846: WHEN NO_DATA_FOUND THEN