DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_SYSTEM_ITEMS_VL

Line 8718: l_item_description mtl_system_items_vl.description%type; --bug 4697949

8714: x_uom_class VARCHAR2(10);
8715: x_uom_count NUMBER(10);
8716: prim_uom_qty NUMBER;
8717: x_error_status VARCHAR2(1);
8718: l_item_description mtl_system_items_vl.description%type; --bug 4697949
8719: BEGIN
8720: x_error_status := rcv_error_pkg.g_ret_sts_error;
8721:
8722: -- If substitute item has been specified then we need to switch the item_id with the

Line 8796: from mtl_system_items_vl

8792: substitute item*/
8793: BEGIN
8794: select description
8795: into l_item_description
8796: from mtl_system_items_vl
8797: where inventory_item_id = x_cascaded_table(n).substitute_item_id
8798: and organization_id = x_cascaded_table(n).to_organization_id;
8799: EXCEPTION
8800: when others then