DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1049: FROM mtl_system_items_kfv

1045: AND request_header_id = p_request_header_id;
1046:
1047: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1048: SELECT inventory_item_id
1049: FROM mtl_system_items_kfv
1050: WHERE inventory_item_id = p_inventory_item_id
1051: AND organization_id = p_org_id;
1052:
1053: CURSOR c_category_id(p_category_id IN NUMBER) IS

Line 1071: FROM mtl_system_items_kfv

1067: AND a.category_set_id = p_category_set_id;
1068:
1069: CURSOR c_product_cost(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1070: SELECT list_price_per_unit
1071: FROM mtl_system_items_kfv
1072: WHERE inventory_item_id = p_inventory_item_id
1073: AND organization_id = p_org_id;
1074:
1075: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS