DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 170: FROM bom_operational_routings bor,

166:
167: -- added for 14157494: Begin -- Check if any routing is present for the line_id
168: SELECT count(1)
169: INTO l_routing_count
170: FROM bom_operational_routings bor,
171: oe_order_lines_all oel
172: WHERE oel.line_id = p_line_id
173: AND oel.INVENTORY_ITEM_ID = bor.assembly_item_id
174: AND oel.ship_from_org_id = bor.organization_id