DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_SYSTEM_ITEMS_VL

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

7771: x_uom_class VARCHAR2(10);
7772: x_uom_count NUMBER(10);
7773: prim_uom_qty NUMBER;
7774: x_error_status VARCHAR2(1);
7775: l_item_description mtl_system_items_vl.description%type; --bug 4697949
7776: BEGIN
7777: x_error_status := rcv_error_pkg.g_ret_sts_error;
7778:
7779: -- If substitute item has been specified then we need to switch the item_id with the

Line 7853: from mtl_system_items_vl

7849: substitute item*/
7850: BEGIN
7851: select description
7852: into l_item_description
7853: from mtl_system_items_vl
7854: where inventory_item_id = x_cascaded_table(n).substitute_item_id
7855: and organization_id = x_cascaded_table(n).to_organization_id;
7856: EXCEPTION
7857: when others then