APPS.IBE_WORKFLOW_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 7170: mtl_system_items_kfv msi

7166: Cursor c_ship_flag(p_line_id NUMBER) IS
7167: SELECT msi.shippable_item_flag
7168: FROM oe_order_lines_all line,
7169: OE_SYSTEM_PARAMETERS_ALL osp,
7170: mtl_system_items_kfv msi
7171: WHERE line.line_id = p_line_id
7172: AND line.org_id = osp.org_id
7173: AND osp.master_organization_id = msi.organization_id
7174: AND line.inventory_item_id = msi.inventory_item_id;

Line 8197: mtl_system_items_kfv msi

8193:
8194: Cursor c_ship_flag(p_line_id NUMBER) IS
8195: SELECT msi.shippable_item_flag
8196: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,
8197: mtl_system_items_kfv msi
8198: WHERE line.line_id = p_line_id
8199: AND line.org_id = osp.org_id
8200: AND osp.master_organization_id = msi.organization_id
8201: AND line.inventory_item_id = msi.inventory_item_id;

Line 9141: l_description mtl_system_items_kfv.description%TYPE;

9137: l_item_key wf_items.item_key%TYPE;
9138: l_quote_id NUMBER;
9139: l_event_type VARCHAR2(20);
9140: l_document VARCHAR2(32000) := '';
9141: l_description mtl_system_items_kfv.description%TYPE;
9142: l_ship_flag VARCHAR2(1);
9143: l_string_in VARCHAR2(250);
9144: l_string_out VARCHAR2(250);
9145: l_string_left VARCHAR2(250);

Line 9153: FROM mtl_system_items_kfv

9149: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9150:
9151: Cursor c_ship_flag(p_inv_item_id NUMBER,p_org_id NUMBER) IS
9152: SELECT shippable_item_flag, rtrim(description) Description
9153: FROM mtl_system_items_kfv
9154: WHERE inventory_item_id = p_inv_item_id
9155: AND organization_id = p_org_id;
9156:
9157: BEGIN