DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 266: mtl_system_items msi

262: WIP_CONSTANTS.RETNEGC_ACTION);
263: SELECT COUNT(*)
264: INTO l_lot_ser_count
265: FROM mtl_transactions_interface mti,
266: mtl_system_items msi
267: WHERE mti.organization_id = msi.organization_id
268: AND mti.inventory_item_id = msi.inventory_item_id
269: AND (msi.lot_control_code = WIP_CONSTANTS.LOT
270: OR

Line 620: from mtl_system_items msi

616: if ( sub_rec.substitution_type_id <> 3 ) then
617: l_result := 0;
618: select 1
619: into l_result
620: from mtl_system_items msi
621: where msi.organization_id = sub_rec.organization_id
622: and msi.inventory_item_id = sub_rec.inventory_item_id
623: and msi.mtl_transactions_enabled_flag = 'Y'
624: and msi.inventory_item_flag = 'Y'

Line 648: from mtl_system_items msi

644: if ( sub_rec.substitution_type_id in (1, 3) ) then
645: l_result := 0;
646: select 1
647: into l_result
648: from mtl_system_items msi
649: where msi.organization_id = sub_rec.organization_id
650: and msi.inventory_item_id = sub_rec.substitution_item_id
651: and msi.mtl_transactions_enabled_flag = 'Y'
652: and msi.inventory_item_flag = 'Y'

Line 838: from mtl_system_items

834: l_service_item_flag := 'N' ;
835:
836: select service_item_flag
837: into l_service_item_flag
838: from mtl_system_items
839: where inventory_item_id = l_compTbl(l_count).inventory_item_id
840: and organization_id = p_orgid ;
841:
842: -- bug 5630078

Line 1544: from mtl_system_items

1540:
1541: -- get the primary txn quantity
1542: select primary_uom_code
1543: into l_primaryUOM
1544: from mtl_system_items
1545: where inventory_item_id = l_flowRec.inventory_item_id
1546: and organization_id = l_flowRec.organization_id;
1547:
1548: if( l_primaryUOM <> l_flowRec.transaction_uom ) then

Line 2153: from mtl_system_items msi

2149: l_service_item_flag := 'Y' ;
2150:
2151: select msi.service_item_flag
2152: into l_service_item_flag
2153: from mtl_system_items msi
2154: where msi.inventory_item_id = x_compTbl(l_count).inventory_item_id
2155: and msi.organization_id = p_orgID ;
2156:
2157: if l_service_item_flag = 'N' then

Line 2184: from mtl_system_items msi,

2180: into l_msiSubinv,
2181: l_msiLocatorID,
2182: l_wpSubinv,
2183: l_wpLocatorID
2184: from mtl_system_items msi,
2185: wip_parameters wp
2186: where msi.organization_id = wp.organization_id
2187: and msi.organization_id = p_orgID
2188: and msi.inventory_item_id = x_compTbl(l_count).inventory_item_id;