DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 341: mtl_system_items msi,

337: ) /* 2620282 : Insert bom revision info */
338: from bom_calendar_dates cal,
339: mtl_parameters mp,
340: wip_parameters wp,
341: mtl_system_items msi,
342: oe_order_lines_all oel
343: where oel.line_id = p_line_id
344: and mp.organization_id = oel.ship_from_org_id
345: and wp.organization_id = mp.organization_id

Line 570: mtl_system_items msi,

566: ) /* 2620282 : Insert bom revision info */
567: from bom_calendar_dates cal,
568: mtl_parameters mp,
569: wip_parameters wp,
570: mtl_system_items msi,
571: oe_order_lines_all oel
572: where oel.line_id = p_line_id
573: and mp.organization_id = oel.ship_from_org_id
574: and wp.organization_id = mp.organization_id

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

785: select 'IMPORTED'
786: into l_imported
787: from oe_order_lines_all oel,
788: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
789: mtl_system_items msi --bugfix 2074290: added msi
790: where oel.line_id = p_line_id
791: and wdd.source_line_id = oel.line_id
792: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
793: and oel.ship_from_org_id = msi.organization_id