APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 730: FROM mtl_system_items msi

726: l_wdd_tbl(1).net_weight,
727: l_wdd_tbl(1).volume_uom_code,
728: l_wdd_tbl(1).unit_volume,
729: l_wdd_tbl(1).volume
730: FROM mtl_system_items msi
731: WHERE msi.inventory_item_id = rti_rec.item_id
732: AND msi.organization_id = p_return_org_id;
733:
734: l_wdd_tbl(1).gross_weight := l_wdd_tbl(1).net_weight;

Line 1906: FROM mtl_system_items msi

1902: --
1903: IF (rti_rec.item_revision IS NOT NULL) THEN
1904: SELECT revision_qty_control_code
1905: INTO l_rev_control
1906: FROM mtl_system_items msi
1907: WHERE msi.organization_id = rti_rec.to_organization_id
1908: AND msi.inventory_item_id = rti_rec.item_id;
1909:
1910: IF (g_asn_debug = 'Y') THEN

Line 2269: FROM mtl_system_items msi,

2265: IF (p_source = 'RCV') THEN
2266: SELECT msi.lot_control_code, msi.serial_number_control_code,
2267: rti.to_organization_id, rti.item_id
2268: INTO l_lot_control, l_serial_control, l_rti_org_id, l_rti_item_id
2269: FROM mtl_system_items msi,
2270: rcv_transactions_interface rti
2271: WHERE msi.organization_id = rti.to_organization_id
2272: AND msi.inventory_item_id = rti.item_id
2273: AND rti.interface_transaction_id = p_parent_id;