APPS.ENG_DEFAULT_REVISED_ITEM dependencies on BOM_OPERATIONAL_ROUTINGS

Line 88: FROM bom_operational_routings

84: BEGIN
85:
86: SELECT routing_sequence_id
87: INTO l_rtg_sequence_id
88: FROM bom_operational_routings
89: WHERE assembly_item_id = g_rev_item_unexp_rec.revised_item_id
90: AND NVL(alternate_routing_designator, 'NONE') =
91: NVL(g_revised_item_rec.alternate_bom_code, 'NONE')
92: AND organization_id = g_rev_item_unexp_rec.organization_id;

Line 600: from BOM_OPERATIONAL_ROUTINGS

596: IF g_rev_item_unexp_rec.routing_sequence_id is NOT NULL THEN
597:
598: Select CFM_ROUTING_FLAG,CTP_FLAG
599: into g_rev_item_unexp_rec.cfm_routing_flag,g_revised_item_rec.ctp_flag
600: from BOM_OPERATIONAL_ROUTINGS
601: where ROUTING_SEQUENCE_ID = g_rev_item_unexp_rec.routing_sequence_id;
602:
603: END IF;
604:

Line 1077: FROM BOM_OPERATIONAL_ROUTINGS

1073: ) RETURN BOOLEAN
1074: IS
1075: cursor c_CheckAlternate IS
1076: SELECT 1
1077: FROM BOM_OPERATIONAL_ROUTINGS
1078: WHERE assembly_item_id = p_revised_item_id
1079: AND organization_id = p_organization_id
1080: AND alternate_routing_designator = p_alternate_bom_designator;
1081: BEGIN

Line 1110: FROM BOM_OPERATIONAL_ROUTINGS

1106: l_routing_type NUMBER := 0;
1107:
1108: cursor c_CheckRtgType IS
1109: SELECT 1
1110: FROM BOM_OPERATIONAL_ROUTINGS
1111: WHERE assembly_item_id = p_revised_item_id
1112: AND organization_id = p_organization_id
1113: AND alternate_routing_designator is null
1114: AND ((routing_type = 1 and l_routing_type = 1)

Line 1416: FROM BOM_OPERATIONAL_ROUTINGS

1412:
1413: CURSOR c_Get_Routing_Seq
1414: IS
1415: SELECT routing_sequence_id
1416: FROM BOM_OPERATIONAL_ROUTINGS
1417: WHERE assembly_item_id = p_rev_item_unexp_rec.revised_item_id
1418: AND organization_id = p_rev_item_unexp_rec.organization_id
1419: AND NVL(alternate_routing_designator, 'none') =
1420: NVL(p_revised_item_rec.alternate_bom_code, 'none');