APPS.WIP_FLOWUTIL_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 278: mtl_system_items msi

274:
275: SELECT COUNT(*)
276: INTO l_lot_ser_count
277: FROM mtl_transactions_interface mti,
278: mtl_system_items msi
279: WHERE mti.organization_id = msi.organization_id
280: AND mti.inventory_item_id = msi.inventory_item_id
281: AND (msi.lot_control_code = WIP_CONSTANTS.LOT
282: OR

Line 295: mtl_system_items msi

291: */
292: SELECT COUNT(*)
293: INTO l_lot_ser_count
294: FROM mtl_transactions_interface mti,
295: mtl_system_items msi
296: WHERE mti.organization_id = msi.organization_id
297: AND mti.inventory_item_id = msi.inventory_item_id
298: AND (msi.lot_control_code = WIP_CONSTANTS.LOT
299: OR

Line 651: from mtl_system_items msi

647: if ( sub_rec.substitution_type_id <> 3 ) then
648: l_result := 0;
649: select 1
650: into l_result
651: from mtl_system_items msi
652: where msi.organization_id = sub_rec.organization_id
653: and msi.inventory_item_id = sub_rec.inventory_item_id
654: and msi.mtl_transactions_enabled_flag = 'Y'
655: and msi.inventory_item_flag = 'Y'

Line 679: from mtl_system_items msi

675: if ( sub_rec.substitution_type_id in (1, 3) ) then
676: l_result := 0;
677: select 1
678: into l_result
679: from mtl_system_items msi
680: where msi.organization_id = sub_rec.organization_id
681: and msi.inventory_item_id = sub_rec.substitution_item_id
682: and msi.mtl_transactions_enabled_flag = 'Y'
683: and msi.inventory_item_flag = 'Y'

Line 869: from mtl_system_items

865: l_service_item_flag := 'N' ;
866:
867: select service_item_flag
868: into l_service_item_flag
869: from mtl_system_items
870: where inventory_item_id = l_compTbl(l_count).inventory_item_id
871: and organization_id = p_orgid ;
872:
873: -- bug 5630078

Line 1575: from mtl_system_items

1571:
1572: -- get the primary txn quantity
1573: select primary_uom_code
1574: into l_primaryUOM
1575: from mtl_system_items
1576: where inventory_item_id = l_flowRec.inventory_item_id
1577: and organization_id = l_flowRec.organization_id;
1578:
1579: if( l_primaryUOM <> l_flowRec.transaction_uom ) then

Line 2192: from mtl_system_items msi

2188: l_service_item_flag := 'Y' ;
2189:
2190: select msi.service_item_flag
2191: into l_service_item_flag
2192: from mtl_system_items msi
2193: where msi.inventory_item_id = x_compTbl(l_count).inventory_item_id
2194: and msi.organization_id = p_orgID ;
2195:
2196: if l_service_item_flag = 'N' then

Line 2223: from mtl_system_items msi,

2219: into l_msiSubinv,
2220: l_msiLocatorID,
2221: l_wpSubinv,
2222: l_wpLocatorID
2223: from mtl_system_items msi,
2224: wip_parameters wp
2225: where msi.organization_id = wp.organization_id
2226: and msi.organization_id = p_orgID
2227: and msi.inventory_item_id = x_compTbl(l_count).inventory_item_id;