DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on MTL_SYSTEM_ITEMS

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

Line 1078: mtl_system_items c

1074:
1075: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1076: SELECT a.uom_code
1077: FROM mtl_units_of_measure a,
1078: mtl_system_items c
1079: WHERE c.primary_unit_of_measure = a.unit_of_measure
1080: AND c.organization_id = p_org_id
1081: AND c.inventory_item_id = p_inventory_item_id
1082: AND uom_code = p_item_uom;