DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1308: FROM mtl_system_items_b_kfv

1304: -- SQLID : 11753349 Fix by musman
1305: -- commented out cursor which are not being used
1306: CURSOR c_inv_item_id(p_inv_item_num IN VARCHAR2) IS
1307: SELECT distinct(inventory_item_id)
1308: FROM mtl_system_items_b_kfv
1309: WHERE segment1 = p_inv_item_num;
1310:
1311: CURSOR c_pricelist_header_id IS
1312: SELECT distinct(pricelist_header_id)

Line 4800: FROM mtl_system_items_b

4796: ,costing_enabled_flag
4797: ,customer_order_flag
4798: ,customer_order_enabled_flag
4799: ,shippable_item_flag
4800: FROM mtl_system_items_b
4801: WHERE inventory_item_id = inv_id
4802: AND organization_id = org_id;
4803:
4804: l_flag_rec get_flag%ROWTYPE;