APPS.BOM_CALC_OP_TIMES_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 77: bom_operational_routings bor

73:
74: SELECT NVL(items.lead_time_lot_size, NVL(items.std_lot_size,1))
75: INTO lot_qty
76: FROM mtl_system_items items,
77: bom_operational_routings bor
78: WHERE items.organization_id = bor.organization_id
79: AND items.inventory_item_id = bor.assembly_item_id
80: AND bor.routing_sequence_id = arg_routing_sequence_id;
81:

Line 208: from bom_bill_of_materials bom, bom_operational_routings bor

204: -- get the BOM to see if there are any option class comps.
205: BEGIN
206: select bill_sequence_id, alternate_bom_designator
207: into x_bom_id, x_alt_bom_desg
208: from bom_bill_of_materials bom, bom_operational_routings bor
209: where routing_sequence_id = arg_routing_sequence_id
210: and bor.assembly_item_id = bom.assembly_item_id
211: and bor.organization_id = bom.organization_id
212: and nvl(bor.alternate_routing_designator, 'NONE')