DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1236: from mtl_item_sub_inventories

1232: DECLARE
1233: l_restricted_sub VARCHAR2(10);
1234: BEGIN
1235: select secondary_inventory into l_restricted_sub
1236: from mtl_item_sub_inventories
1237: where organization_id = p_organization_id
1238: and inventory_item_id = l_inventory_item_id
1239: and secondary_inventory = p_to_subinventory_code;
1240: EXCEPTION

Line 1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);

1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;
1252: RAISE EXCP_USER_DEFINED;
1253: END;
1254: END IF;