APPS.RCV_EXPRESS_SV dependencies on MTL_SYSTEM_ITEMS

Line 561: from mtl_system_items msi

557: if ( not(X_txn_from_web or X_txn_from_wf) ) then--Bug 5855096
558: if (nvl(rcv_trx.item_id,0) <> 0) then
559: select nvl(msi.allow_express_delivery_flag,'U') --Bug 5855096
560: into x_allow_express_delivery_flag
561: from mtl_system_items msi
562: where msi.inventory_item_id =rcv_trx.item_id
563: and msi.organization_id = rcv_trx.to_organization_id;
564:
565: if x_allow_express_delivery_flag = 'N' then

Line 592: from mtl_system_items msi

588: select msi.segment1,
589: msi.stock_enabled_flag
590: into x_item_name,
591: x_stock_enabled_flag
592: from mtl_system_items msi
593: where msi.inventory_item_id = rcv_trx.item_id
594: and msi.organization_id = rcv_trx.to_organization_id;
595:
596:

Line 846: FROM mtl_system_items_kfv msi

842: BEGIN
843:
844: SELECT msi.revision_qty_control_code
845: INTO l_item_rev_control
846: FROM mtl_system_items_kfv msi
847: WHERE msi.inventory_item_id = rcv_trx.item_id
848: AND msi.organization_id = rcv_trx.to_organization_id;
849:
850: IF ( nvl(l_item_rev_control,1) = 2 ) THEN

Line 1378: FROM mtl_system_items_kfv msi

1374: X_progress := 400;
1375:
1376: SELECT msi.revision_qty_control_code
1377: INTO X_item_rev_control
1378: FROM mtl_system_items_kfv msi
1379: WHERE rcv_trx.item_id = msi.inventory_item_id
1380: AND rcv_trx.to_organization_id = msi.organization_id;
1381:
1382: /*