DBA Data[Home] [Help]

APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 908: l_description mtl_system_items_kfv.description%TYPE;

904: l_item_key wf_items.item_key%TYPE;
905: l_quote_id NUMBER;
906: l_event_type VARCHAR2(20);
907: l_document VARCHAR2(32000) := '';
908: l_description mtl_system_items_kfv.description%TYPE;
909: l_ship_flag VARCHAR2(1);
910: l_string_in VARCHAR2(250);
911: l_string_out VARCHAR2(250);
912: l_string_left VARCHAR2(250);

Line 921: FROM mtl_system_items_kfv

917: l_curr_sym Varchar2(12);
918:
919: Cursor c_ship_flag(p_inv_item_id NUMBER,p_org_id NUMBER) IS
920: SELECT shippable_item_flag, rtrim(description) Description
921: FROM mtl_system_items_kfv
922: WHERE inventory_item_id = p_inv_item_id
923: AND organization_id = p_org_id;
924:
925: Cursor c_quote_detail (p_quote_id NUMBER) IS