APPS.MRP_DEFAULT_FLOW_SCHEDULE dependencies on BOM_OPERATIONAL_ROUTINGS

Line 36: FROM bom_operational_routings

32: CURSOR C1(p_item_id IN NUMBER,
33: p_org_id IN NUMBER,
34: p_line_id IN NUMBER) IS
35: SELECT alternate_routing_designator
36: FROM bom_operational_routings
37: WHERE line_id = p_line_id
38: AND assembly_item_id = p_item_id
39: AND organization_id = p_org_id
40: AND cfm_routing_flag = 1

Line 511: FROM bom_operational_routings

507: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
508: THEN
509: SELECT line_id
510: INTO l_line_id
511: FROM bom_operational_routings
512: WHERE cfm_routing_flag = 1
513: AND ((alternate_routing_designator IS NULL) OR
514: (alternate_routing_designator IS NOT NULL
515: AND priority = (SELECT min(priority)

Line 516: FROM bom_operational_routings

512: WHERE cfm_routing_flag = 1
513: AND ((alternate_routing_designator IS NULL) OR
514: (alternate_routing_designator IS NOT NULL
515: AND priority = (SELECT min(priority)
516: FROM bom_operational_routings
517: WHERE cfm_routing_flag = 1
518: AND assembly_item_id = g_flow_schedule_rec.primary_item_id
519: AND organization_id = g_flow_schedule_rec.organization_id
520: AND NOT EXISTS (SELECT line_id FROM bom_operational_routings

Line 520: AND NOT EXISTS (SELECT line_id FROM bom_operational_routings

516: FROM bom_operational_routings
517: WHERE cfm_routing_flag = 1
518: AND assembly_item_id = g_flow_schedule_rec.primary_item_id
519: AND organization_id = g_flow_schedule_rec.organization_id
520: AND NOT EXISTS (SELECT line_id FROM bom_operational_routings
521: WHERE cfm_routing_flag = 1
522: AND alternate_routing_designator IS NULL
523: AND assembly_item_id = g_flow_schedule_rec.primary_item_id
524: AND organization_id = g_flow_schedule_rec.organization_id