APPS.AHL_OSP_COST_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

    SELECT osp_order_line_id, osp_order_id, service_item_id, service_item_description,
           service_item_uom_code, quantity, po_line_id, inventory_org_id
    FROM AHL_OSP_ORDER_LINES
    WHERE WORKORDER_ID = p_workorder_id
      AND STATUS_CODE IS NULL;  -- (Not PO_CANCELLED or PO_DELETED)

Line: 47

    SELECT ospl.osp_order_line_id, ospl.osp_order_id, ospl.service_item_id, ospl.service_item_description,
           ospl.service_item_uom_code, ospl.quantity, ospl.po_line_id, ospl.inventory_org_id,
           ospl.po_req_line_id, locs.po_line_id req_loc_po_line_id
    FROM AHL_OSP_ORDER_LINES ospl, PO_REQUISITION_LINES_ALL reql, PO_LINE_LOCATIONS_ALL locs
    WHERE ospl.WORKORDER_ID = p_workorder_id
      AND ospl.STATUS_CODE IS NULL  -- (Not PO_CANCELLED or PO_DELETED)
      AND ospl.po_req_line_id = reql.requisition_line_id (+)
      AND reql.LINE_LOCATION_ID = locs.LINE_LOCATION_ID (+);

Line: 58

  SELECT pol.unit_price*pol.quantity extended_price, po.currency_code
   from po_lines_all pol, po_headers_all po
   WHERE po_line_id = p_po_line_id
     AND pol.po_header_id = po.po_header_id;

Line: 65

  SELECT reql.unit_price*reql.quantity extended_price, reql.currency_code
   from PO_REQUISITION_LINES_ALL reql
   WHERE requisition_line_id = p_req_line_id;

Line: 70

   select   currency_code
     from   cst_acct_info_v COD,
	    GL_SETS_OF_BOOKS GSOB
    where   COD.Organization_Id = p_org_id
      AND   LEDGER_ID = GSOB.SET_OF_BOOKS_ID
      AND   NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();

Line: 84

    SELECT vst.organization_id from
           ahl_workorders wo,
           ahl_visit_tasks_b vts,
           ahl_visits_b vst
     WHERE wo.visit_task_id = vts.visit_task_id
       AND vts.visit_id = vst.visit_id
       AND wo.WORKORDER_ID = p_workorder_id;

Line: 95

    SELECT status_code, po_header_id, order_type_code
    FROM AHL_OSP_ORDERS_B
    WHERE OSP_ORDER_ID = p_osp_order_id;

Line: 101

    SELECT LIST_PRICE_PER_UNIT, PRIMARY_UOM_CODE
    FROM MTL_SYSTEM_ITEMS_KFV
    WHERE INVENTORY_ITEM_ID = p_item_id
      AND ORGANIZATION_ID = p_org_id;