APPS.OE_DS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 366: item-REVISION_QTY_CONTROL_CODE in MTL_SYSTEM_ITEMS and pass the

362: ** Fetch receiving transaction information: lot number, item revision
363: ** subinventory, receiving quantity and transactable flag.
364: */
365: /* Bug2197831:Added a decode statement to check the revision of
366: item-REVISION_QTY_CONTROL_CODE in MTL_SYSTEM_ITEMS and pass the
367: value of the revision or NULL accordingly.
368: */
369: BEGIN
370:

Line 403: FROM mtl_system_items mi,

399: l_sn_control_code,
400: l_as_alpha_prefix,
401: l_transfer_lpn_id, -- bug 3544019
402: l_rcv_primary_quantity -- 12794393
403: FROM mtl_system_items mi,
404: mtl_secondary_inventories msinv,
405: rcv_shipment_lines rs,
406: rcv_transactions rt
407: WHERE rt.transaction_id = l_transaction_id

Line 582: FROM mtl_system_items

578:
579: BEGIN
580: SELECT NVL(reservable_type,2)
581: INTO l_item_reservable
582: FROM mtl_system_items
583: WHERE inventory_item_id = l_line_rec.inventory_item_id
584: AND organization_id = l_line_rec.ship_from_org_id;
585:
586: IF l_debug_level > 0 THEN

Line 1107: FROM mtl_system_items

1103:
1104: BEGIN
1105: SELECT primary_uom_code
1106: INTO l_primary_uom
1107: FROM mtl_system_items
1108: WHERE inventory_item_id = p_line_rec.inventory_item_id
1109: AND organization_id = p_line_rec.ship_from_org_id;
1110: EXCEPTION
1111: WHEN NO_DATA_FOUND THEN

Line 1966: From mtl_system_items

1962: l_exist NUMBER := 0;
1963:
1964: Cursor get_opm_item_no IS
1965: Select distinct segment1
1966: From mtl_system_items
1967: Where inventory_item_id = p_inventory_item_id
1968: and organization_id = p_warehouse_id;
1969:
1970: Cursor get_opm_item_id IS