DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on WIP_FLOW_SCHEDULES

Line 2079: FROM wip_flow_schedules

2075: AND bom.bill_sequence_id = bic.bill_sequence_id
2076: AND bic.operation_seq_num > 1)
2077: OR EXISTS (
2078: SELECT 1 /* Check if flow schedule exists for primary */
2079: FROM wip_flow_schedules
2080: WHERE organization_id = p_org_id
2081: AND primary_item_id = p_ass_itm_id
2082: AND alternate_routing_designator IS NULL)
2083: OR EXISTS (

Line 2085: FROM wip_flow_schedules

2081: AND primary_item_id = p_ass_itm_id
2082: AND alternate_routing_designator IS NULL)
2083: OR EXISTS (
2084: SELECT 1 /* Check if flow schedule exists for alternate */
2085: FROM wip_flow_schedules
2086: WHERE organization_id = p_org_id
2087: AND primary_item_id = p_ass_itm_id
2088: AND alternate_routing_designator = p_alt_rtg_desg)
2089: OR EXISTS (