DBA Data[Home] [Help]

APPS.AHL_OSP_COST_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 102: FROM MTL_SYSTEM_ITEMS_KFV

98:
99: CURSOR get_item_dtls_csr(p_item_id IN NUMBER,
100: p_org_id IN NUMBER) IS
101: SELECT LIST_PRICE_PER_UNIT, PRIMARY_UOM_CODE
102: FROM MTL_SYSTEM_ITEMS_KFV
103: WHERE INVENTORY_ITEM_ID = p_item_id
104: AND ORGANIZATION_ID = p_org_id;
105: --
106: l_api_name CONSTANT VARCHAR2(30) := 'Get_OSP_Cost';

Line 111: l_temp_uom_code MTL_SYSTEM_ITEMS_KFV.PRIMARY_UOM_CODE%TYPE;

107: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_OSP_Cost';
108: l_osp_line_rec get_osp_line_dtls_csr%ROWTYPE;
109: l_osp_order_rec get_osp_order_dtls_csr%ROWTYPE;
110: -- l_inv_org_id NUMBER;
111: l_temp_uom_code MTL_SYSTEM_ITEMS_KFV.PRIMARY_UOM_CODE%TYPE;
112: l_unit_price NUMBER;
113: l_converted_qty NUMBER;
114: --
115: BEGIN