DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 7075: mtl_system_items_kfv msi

7071: Cursor c_ship_flag(p_line_id NUMBER) IS
7072: SELECT msi.shippable_item_flag
7073: FROM oe_order_lines_all line,
7074: OE_SYSTEM_PARAMETERS_ALL osp,
7075: mtl_system_items_kfv msi
7076: WHERE line.line_id = p_line_id
7077: AND line.org_id = osp.org_id
7078: AND osp.master_organization_id = msi.organization_id
7079: AND line.inventory_item_id = msi.inventory_item_id;

Line 8102: mtl_system_items_kfv msi

8098:
8099: Cursor c_ship_flag(p_line_id NUMBER) IS
8100: SELECT msi.shippable_item_flag
8101: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,
8102: mtl_system_items_kfv msi
8103: WHERE line.line_id = p_line_id
8104: AND line.org_id = osp.org_id
8105: AND osp.master_organization_id = msi.organization_id
8106: AND line.inventory_item_id = msi.inventory_item_id;

Line 9046: l_description mtl_system_items_kfv.description%TYPE;

9042: l_item_key wf_items.item_key%TYPE;
9043: l_quote_id NUMBER;
9044: l_event_type VARCHAR2(20);
9045: l_document VARCHAR2(32000) := '';
9046: l_description mtl_system_items_kfv.description%TYPE;
9047: l_ship_flag VARCHAR2(1);
9048: l_string_in VARCHAR2(250);
9049: l_string_out VARCHAR2(250);
9050: l_string_left VARCHAR2(250);

Line 9058: FROM mtl_system_items_kfv

9054: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9055:
9056: Cursor c_ship_flag(p_inv_item_id NUMBER,p_org_id NUMBER) IS
9057: SELECT shippable_item_flag, rtrim(description) Description
9058: FROM mtl_system_items_kfv
9059: WHERE inventory_item_id = p_inv_item_id
9060: AND organization_id = p_org_id;
9061:
9062: BEGIN