DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on WIP_FLOW_SCHEDULES

Line 2143: FROM wip_flow_schedules

2139: AND bom.bill_sequence_id = bic.bill_sequence_id
2140: AND bic.operation_seq_num > 1)
2141: OR EXISTS (
2142: SELECT 1 /* Check if flow schedule exists for primary */
2143: FROM wip_flow_schedules
2144: WHERE organization_id = p_org_id
2145: AND primary_item_id = p_ass_itm_id
2146: AND alternate_routing_designator IS NULL)
2147: OR EXISTS (

Line 2149: FROM wip_flow_schedules

2145: AND primary_item_id = p_ass_itm_id
2146: AND alternate_routing_designator IS NULL)
2147: OR EXISTS (
2148: SELECT 1 /* Check if flow schedule exists for alternate */
2149: FROM wip_flow_schedules
2150: WHERE organization_id = p_org_id
2151: AND primary_item_id = p_ass_itm_id
2152: AND alternate_routing_designator = p_alt_rtg_desg)
2153: OR EXISTS (