APPS.AHL_OSP_UTIL_PKG SQL Statements

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

Line: 81

  AHL_OSP_ORDER_LOGS_PKG.INSERT_ROW(
    X_OSP_ORDER_LOG_ID          => l_osp_order_log_id,
    X_OBJECT_VERSION_NUMBER     => 1,
    X_LAST_UPDATE_DATE          => SYSDATE,
    X_LAST_UPDATED_BY           => fnd_global.user_id,
    X_CREATION_DATE             => SYSDATE,
    X_CREATED_BY                => fnd_global.user_id,
    X_LAST_UPDATE_LOGIN         => fnd_global.login_id,
    X_TRANSACTION_DATE          => SYSDATE,
    X_TRANSACTION_TYPE_CODE     => p_trans_type_code,
    X_SOURCE_DOCUMENT_ID        => p_src_doc_id,
    X_SOURCE_DOCUMENT_TYPE_CODE => p_src_doc_type_code,
    X_DESTINATION_DOCUMENT_ID   => p_dest_doc_id,
    X_DEST_DOCUMENT_TYPE_CODE   => p_dest_doc_type_code,
    X_TRANSACTION_STATUS_CODE   => L_DUMMY_TXN_STATUS_CODE,
    X_PROGRAM_ID                => AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
    X_ATTRIBUTE_CATEGORY        => p_attribute_category,
    X_ATTRIBUTE1                => p_attribute1,
    X_ATTRIBUTE2                => p_attribute2,
    X_ATTRIBUTE3                => p_attribute3,
    X_ATTRIBUTE4                => p_attribute4,
    X_ATTRIBUTE5                => p_attribute5,
    X_ATTRIBUTE6                => p_attribute6,
    X_ATTRIBUTE7                => p_attribute7,
    X_ATTRIBUTE8                => p_attribute8,
    X_ATTRIBUTE9                => p_attribute9,
    X_ATTRIBUTE10               => p_attribute10,
    X_ATTRIBUTE11               => p_attribute11,
    X_ATTRIBUTE12               => p_attribute12,
    X_ATTRIBUTE13               => p_attribute13,
    X_ATTRIBUTE14               => p_attribute14,
    X_ATTRIBUTE15               => p_attribute15);

Line: 593

     SELECT oe_ship_line_id,
            oe_return_line_id,
            workorder_id,
            serial_number,
            lot_number,
            osp_order_id,
            exchange_instance_id
     FROM ahl_osp_order_lines
     WHERE osp_order_line_id = p_osp_line_id;

Line: 604

     SELECT order_type_code FROM ahl_osp_orders_b
     WHERE osp_order_id = c_osp_order_id;

Line: 609

     SELECT instance_number FROM csi_item_instances
     WHERE instance_id = c_instance_id;

Line: 661

     SELECT oe_ship_line_id,
            oe_return_line_id,
            workorder_id,
            serial_number,
            lot_number,
            osp_order_id,
            exchange_instance_id
     FROM ahl_osp_order_lines
     WHERE osp_order_line_id = p_osp_line_id;

Line: 672

     SELECT order_type_code FROM ahl_osp_orders_b
     WHERE osp_order_id = c_osp_order_id;

Line: 676

     SELECT instance_number FROM csi_item_instances
     WHERE instance_id = c_instance_id;

Line: 716

     SELECT oe_ship_line_id,
            oe_return_line_id,
            serial_number,
            lot_number,
            osp_order_id,
            exchange_instance_id
     FROM ahl_osp_order_lines
     WHERE osp_order_line_id = p_osp_line_id;

Line: 726

     SELECT order_type_code from ahl_osp_orders_b
     WHERE osp_order_id = c_osp_order_id;

Line: 730

     SELECT serial_number FROM csi_item_instances
     WHERE instance_id = c_instance_id;

Line: 734

     SELECT FROM_SERIAL_NUMBER from oe_lot_serial_numbers
     where LINE_ID = p_ship_line_id;

Line: 792

     SELECT oe_ship_line_id,
            oe_return_line_id,
            serial_number,
            lot_number,
            osp_order_id,
            exchange_instance_id
     FROM ahl_osp_order_lines
     WHERE osp_order_line_id = p_osp_line_id;

Line: 802

     SELECT order_type_code from ahl_osp_orders_b
     WHERE osp_order_id = c_osp_order_id;

Line: 806

     SELECT lot_number FROM csi_item_instances
     WHERE instance_id = c_instance_id;

Line: 810

     SELECT LOT_NUMBER from oe_lot_serial_numbers
     where LINE_ID = p_ship_line_id;

Line: 867

     SELECT csi.instance_number
     FROM AHL_WORKORDERS WO, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS, CSI_ITEM_INSTANCES CSI
     WHERE WO.WORKORDER_ID = p_workorder_id AND
      WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
      VST.VISIT_ID = VTS.VISIT_ID AND
      NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID) = CSI.INSTANCE_ID;

Line: 875

     SELECT instance_number FROM CSI_ITEM_INSTANCES
     WHERE serial_number = p_serial_number;

Line: 879

     SELECT instance_number FROM csi_item_instances
     WHERE lot_number = p_lot_number;

Line: 912

    SELECT tld.instance_id
      FROM csi_t_transaction_lines tl,
           csi_t_txn_line_details tld
     WHERE tl.source_transaction_id = p_oe_line_id
       AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
       AND tl.transaction_line_id = tld.transaction_line_id;