DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FLM_EXE_SERIAL_NUMBERS

Line 3711: delete from flm_exe_serial_numbers

3707: delete from flm_exe_req_operations
3708: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3709: delete from flm_exe_lot_numbers
3710: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3711: delete from flm_exe_serial_numbers
3712: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3713: END IF;
3714:
3715: END LOOP;

Line 7099: UPDATE flm_exe_serial_numbers

7095: SET wip_entity_id=newFSWipId(i)
7096: WHERE wip_entity_id=oldFSWipId(i)
7097: AND organization_id=p_organization_id;
7098: FORALL i IN 1..l_loop_count
7099: UPDATE flm_exe_serial_numbers
7100: SET wip_entity_id=newFSWipId(i)
7101: WHERE wip_entity_id=oldFSWipId(i)
7102: AND organization_id=p_organization_id;
7103: