DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 325: mtl_system_items msi,

321: ) /* 2620282 : Insert bom revision info */
322: from bom_calendar_dates cal,
323: mtl_parameters mp,
324: wip_parameters wp,
325: mtl_system_items msi,
326: oe_order_lines_all oel
327: where oel.line_id = p_line_id
328: and mp.organization_id = oel.ship_from_org_id
329: and wp.organization_id = mp.organization_id

Line 552: mtl_system_items msi,

548: ) /* 2620282 : Insert bom revision info */
549: from bom_calendar_dates cal,
550: mtl_parameters mp,
551: wip_parameters wp,
552: mtl_system_items msi,
553: oe_order_lines_all oel
554: where oel.line_id = p_line_id
555: and mp.organization_id = oel.ship_from_org_id
556: and wp.organization_id = mp.organization_id

Line 771: mtl_system_items msi --bugfix 2074290: added msi

767: select 'IMPORTED'
768: into l_imported
769: from oe_order_lines_all oel,
770: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
771: mtl_system_items msi --bugfix 2074290: added msi
772: where oel.line_id = p_line_id
773: and wdd.source_line_id = oel.line_id
774: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
775: and oel.ship_from_org_id = msi.organization_id