DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FLM_EXE_SERIAL_NUMBERS

Line 3708: delete from flm_exe_serial_numbers

3704: delete from flm_exe_req_operations
3705: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3706: delete from flm_exe_lot_numbers
3707: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3708: delete from flm_exe_serial_numbers
3709: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3710: END IF;
3711:
3712: END LOOP;

Line 7074: UPDATE flm_exe_serial_numbers

7070: SET wip_entity_id=newFSWipId(i)
7071: WHERE wip_entity_id=oldFSWipId(i)
7072: AND organization_id=p_organization_id;
7073: FORALL i IN 1..l_loop_count
7074: UPDATE flm_exe_serial_numbers
7075: SET wip_entity_id=newFSWipId(i)
7076: WHERE wip_entity_id=oldFSWipId(i)
7077: AND organization_id=p_organization_id;
7078: