DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on MTL_SYSTEM_ITEMS

Line 550: from mtl_system_items msi

546: if ( not(X_txn_from_web or X_txn_from_wf) ) then--Bug 5855096
547: if (nvl(rcv_trx.item_id,0) <> 0) then
548: select nvl(msi.allow_express_delivery_flag,'U') --Bug 5855096
549: into x_allow_express_delivery_flag
550: from mtl_system_items msi
551: where msi.inventory_item_id =rcv_trx.item_id
552: and msi.organization_id = rcv_trx.to_organization_id;
553:
554: if x_allow_express_delivery_flag = 'N' then

Line 581: from mtl_system_items msi

577: select msi.segment1,
578: msi.stock_enabled_flag
579: into x_item_name,
580: x_stock_enabled_flag
581: from mtl_system_items msi
582: where msi.inventory_item_id = rcv_trx.item_id
583: and msi.organization_id = rcv_trx.to_organization_id;
584:
585:

Line 835: FROM mtl_system_items_kfv msi

831: BEGIN
832:
833: SELECT msi.revision_qty_control_code
834: INTO l_item_rev_control
835: FROM mtl_system_items_kfv msi
836: WHERE msi.inventory_item_id = rcv_trx.item_id
837: AND msi.organization_id = rcv_trx.to_organization_id;
838:
839: IF ( nvl(l_item_rev_control,1) = 2 ) THEN

Line 1273: FROM mtl_system_items_kfv msi

1269: X_progress := 400;
1270:
1271: SELECT msi.revision_qty_control_code
1272: INTO X_item_rev_control
1273: FROM mtl_system_items_kfv msi
1274: WHERE rcv_trx.item_id = msi.inventory_item_id
1275: AND rcv_trx.to_organization_id = msi.organization_id;
1276:
1277: /*