APPS.WIP_FLOW_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 18: FROM mtl_system_items

14: BEGIN
15:
16:
17: Select PRIMARY_UOM_CODE INTO x_primary_uom
18: FROM mtl_system_items
19: WHERE inventory_item_Id = p_item_id
20: AND organization_Id = p_org_id;
21:
22: -- Call the Inventory Conversion Routine to get the Quantity

Line 163: from mtl_system_items

159: if (Sub_Rec.substitution_type_id <> 3) then
160:
161: x_success := 0;
162: select 1 into x_success
163: from mtl_system_items
164: where organization_id = p_organization_id
165: and inventory_item_id = Sub_Rec.inventory_item_id
166: and mtl_transactions_enabled_flag = 'Y'
167: and inventory_item_flag = 'Y'

Line 192: from mtl_system_items

188: if (Sub_Rec.substitution_type_id in(1,3) ) then
189:
190: x_success := 0;
191: select 1 into x_success
192: from mtl_system_items
193: where organization_id = p_organization_id
194: and inventory_item_id = Sub_Rec.substitution_item_id
195: and mtl_transactions_enabled_flag = 'Y'
196: and inventory_item_flag = 'Y'

Line 564: FROM MTL_SYSTEM_ITEMS msi

560: AND PROCESS_FLAG = 2
561: AND REVISION IS NULL
562: AND EXISTS (
563: SELECT 'X'
564: FROM MTL_SYSTEM_ITEMS msi
565: WHERE msi.ORGANIZATION_ID = mti.ORGANIZATION_ID
566: AND msi.inventory_item_id = mti.inventory_item_id
567: AND msi.revision_qty_control_code = 2);
568:

Line 2331: mtl_system_items_kfv msi

2327: mti.transfer_cost_group_id cost_group_id,
2328: least( 1, NVL(mti.transfer_lpn_id, 0) + NVL(mti.content_lpn_id, 0) ) containerized,
2329: mti.transaction_header_id -- bugfix 4455722
2330: from mtl_transactions_interface mti,
2331: mtl_system_items_kfv msi
2332: where mti.parent_id = txn_interface_id
2333: and nvl(mti.operation_seq_num, 1) > 0 /* not for phatom assembly */
2334: and mti.transaction_action_id in (1,27,33,34) /*wip_constants.isscomp_action, wip_constants.retcomp_action, wip_constants.issnegc_action, wip_constants.retnegc_action)*/
2335: and mti.inventory_item_id = msi.inventory_item_id

Line 2464: From mtl_system_items_b t

2460:
2461: l_more := l_compObj.getcurrentitem(l_cur_item);
2462:
2463: select decode(t.revision_qty_control_code, 2, 'T', 'F') into l_rev_code
2464: From mtl_system_items_b t
2465: Where t.inventory_item_id = l_lotItemsRecords.inventory_item_id
2466: and t.organization_id = l_lotItemsRecords.organization_id;
2467:
2468: if ( l_rev_code = 'T' ) then