DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 7246: l_routing_type bom_operational_routings.cfm_routing_flag%type;

7242: l_ext_req_secondary_qty Number;
7243: l_int_req_secondary_qty Number;
7244:
7245: -- Bugfix 16236435
7246: l_routing_type bom_operational_routings.cfm_routing_flag%type;
7247:
7248: BEGIN
7249:
7250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7280: bom_operational_routings bor

7276: l_item_id,
7277: l_routing_type
7278: from mtl_system_items msi,
7279: oe_order_lines_all oel,
7280: bom_operational_routings bor
7281: where msi.inventory_item_id = oel.inventory_item_id
7282: and msi.organization_id = oel.ship_from_org_id
7283: and oel.line_id = p_order_line_id
7284: and oel.inventory_item_id = bor.assembly_item_id(+)