DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on WIP_FLOW_SCHEDULES

Line 1327: from WIP_FLOW_SCHEDULES wfs

1323: CURSOR flow_sched_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1324: select SUM(GREATEST( 0, (wfs.planned_quantity - wfs.quantity_completed
1325: - wfs.quantity_scrapped))) item_qty,
1326: wfs.wip_entity_id --added for bug 6886708 for logging
1327: from WIP_FLOW_SCHEDULES wfs
1328: where wfs.status = 1
1329: and wfs.SCHEDULED_FLAG = 1
1330: and wfs.organization_id = p_org_id
1331: and wfs.primary_item_id = p_inv_item_id