DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1249: FROM mtl_system_items_kfv

1245: AND request_header_id = p_request_header_id;
1246:
1247: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1248: SELECT inventory_item_id
1249: FROM mtl_system_items_kfv
1250: WHERE inventory_item_id = p_inventory_item_id
1251: AND organization_id = p_org_id;
1252:
1253: CURSOR c_category_id(p_category_id IN NUMBER) IS

Line 1281: FROM mtl_system_items_kfv

1277: AND c.category_id = p_category_id;
1278:
1279: CURSOR c_product_cost(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1280: SELECT list_price_per_unit
1281: FROM mtl_system_items_kfv
1282: WHERE inventory_item_id = p_inventory_item_id
1283: AND organization_id = p_org_id;
1284:
1285: --//Bugfix : 12538544