DBA Data[Home] [Help]

APPS.WSH_CARRIERS_PUB SQL Statements

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

Line: 98

         SELECT CARRIER_SERVICE_ID,
         ATTRIBUTE_CATEGORY ,
         ATTRIBUTE1 ,
         ATTRIBUTE2 ,
         ATTRIBUTE3 ,
         ATTRIBUTE4 ,
         ATTRIBUTE5 ,
         ATTRIBUTE6 ,
         ATTRIBUTE7 ,
         ATTRIBUTE8 ,
         ATTRIBUTE9 ,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15
         FROM WSH_CARRIER_SERVICES
         WHERE carrier_service_id = l_carrier_service_id
         AND enabled_flag = 'Y';
Line: 121

         SELECT CARRIER_SERVICE_ID,
         ATTRIBUTE_CATEGORY ,
         ATTRIBUTE1 ,
         ATTRIBUTE2 ,
         ATTRIBUTE3 ,
         ATTRIBUTE4 ,
         ATTRIBUTE5 ,
         ATTRIBUTE6 ,
         ATTRIBUTE7 ,
         ATTRIBUTE8 ,
         ATTRIBUTE9 ,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15
         FROM WSH_CARRIER_SERVICES
         WHERE ship_method_code = l_ship_method_code
         AND enabled_flag = 'Y';
Line: 144

         SELECT CARRIER_SERVICE_ID,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15
         FROM WSH_CARRIER_SERVICES
         WHERE carrier_id = l_carrier_id
         AND enabled_flag = 'Y';