DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on WIP_FLOW_SCHEDULES

Line 1398: from WIP_FLOW_SCHEDULES wfs

1394: CURSOR flow_sched_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1395: select SUM(GREATEST( 0, (wfs.planned_quantity - wfs.quantity_completed
1396: - wfs.quantity_scrapped))) item_qty,
1397: wfs.wip_entity_id --added for bug 6886708 for logging
1398: from WIP_FLOW_SCHEDULES wfs
1399: where wfs.status = 1
1400: and wfs.SCHEDULED_FLAG = 1
1401: and wfs.organization_id = p_org_id
1402: and wfs.primary_item_id = p_inv_item_id