DBA Data[Home] [Help]

APPS.BOMPCHDU dependencies on BOM_OPERATIONAL_ROUTINGS

Line 276: bom_operational_routings bor

272: */
273:
274: select NVL(cfm_routing_flag,0) into cfm_value
275: from mtl_demand md,
276: bom_operational_routings bor
277: where md.inventory_item_id = bor.assembly_item_id(+)
278: and md.organization_id = bor.organization_id(+)
279: and bor.alternate_routing_designator(+) is NULL
280: and md.demand_id = input_demand_id;

Line 292: bom_operational_routings bor,

288: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
289: so_lines_all solp, /* Parent of ATO Model if any */
290: so_lines_all sol1, /* processing */
291: mtl_system_items msi,
292: bom_operational_routings bor,
293: bom_parameters bp
294: where BAC1.base_model_id = sol1.inventory_item_id
295: and BAC1.organization_id = sol1.warehouse_id
296: and BAC1.component_item_id = sol1.inventory_item_id