APPS.WMS_OTM_DOCK_SYNC SQL Statements

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

Line: 44

    SELECT 'ORG-' || ORGANIZATION_ID ||'-'|| LOCATION_ID LOCATION_XID
    FROM   WSH_SHIP_FROM_ORGS_V
    WHERE  ORGANIZATION_ID = l_organization_id;

Line: 51

    SELECT 'DOCK-' || inventory_location_id LOCATION_RES_XID,
           NVL(description, 'DOCK-' || inventory_location_id||' Name') LOCATION_RES_NAME
    FROM   mtl_item_locations
    WHERE  organization_id = l_organization_id
    AND    inventory_location_type = 1;

Line: 166

  SELECT ticket, operation, argument, end_date
  FROM   FND_HTTP_TICKETS
  WHERE  operation = c_operation
  AND    argument  = c_argument;

Line: 172

  SELECT SYSDATE FROM DUAL;

Line: 198

        print_debug('Tickets Exists but expired. Delete existing', 4);