DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_DISCRETE_JOBS

Line 966: from mtl_system_items msi,wip_discrete_jobs wdj,mtl_secondary_inventories sub, mtl_parameters mp

962: l_locationcontrol,
963: l_subLocCtl,
964: l_orgLocCtl,
965: l_project_id,l_task_id
966: from mtl_system_items msi,wip_discrete_jobs wdj,mtl_secondary_inventories sub, mtl_parameters mp
967: where msi.inventory_item_id = l_inventory_itemid
968: and msi.organization_id = p_organization_id
969: and wdj.organization_id=msi.organization_id
970: and wdj.wip_entity_id=p_wip_entity_id

Line 1384: FROM WIP_DISCRETE_JOBS

1380:
1381: begin
1382: SELECT start_quantity
1383: INTO X_start_quantity
1384: FROM WIP_DISCRETE_JOBS
1385: WHERE wip_entity_id = p_wip_entity_id
1386: AND organization_id = p_organization_id;
1387:
1388: /*Component Yield Enhancement(Bug 4369064)->Get the current values of qpa, req_qty and yield*/