APPS.OE_AR_ACCEPTANCE_GRP SQL Statements

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

Line: 155

    SELECT order_number
    INTO x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1
    FROM oe_order_headers_all
    WHERE header_id= l_line_rec.header_id;

Line: 160

    SELECT tt.name
    INTO   x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2
    FROM   oe_transaction_types_tl tt,
            oe_order_headers oh
    WHERE  tt.language = ( select language_code
                         from   fnd_languages
                         where  installed_flag = 'B')
    AND    tt.transaction_type_id = oh.order_type_id
    AND    oh.header_id = l_line_rec.header_id;

Line: 184

	       SELECT min(dl.delivery_id)
	       INTO   l_delivery_line_id
	       FROM   wsh_new_deliveries dl,
                      wsh_delivery_assignments da,
                      wsh_delivery_details dd
               WHERE  dd.delivery_detail_id  = da.delivery_detail_id
	       AND    da.delivery_id  = dl.delivery_id
               AND    dd.source_code = 'OE'
               AND    dd.source_line_id = l_line_rec.line_id;

Line: 208

	       SELECT min(dl.delivery_id)
               INTO   l_delivery_line_id
               FROM wsh_new_deliveries dl,
                    wsh_delivery_assignments da,
                    wsh_delivery_details dd
               WHERE   dd.delivery_detail_id  = da.delivery_detail_id
               AND     da.delivery_id  = dl.delivery_id
               AND     dd.source_code = 'OE'
               AND     dd.top_model_line_id = l_line_rec.line_id;

Line: 230

              SELECT  NVL(SUBSTR(dl.name, 1, 30), '0')
                      ,NVL(SUBSTR(dl.waybill, 1, 30), '0')
              INTO    x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3
                      ,x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4
              FROM   wsh_new_deliveries dl
              WHERE dl.delivery_id = l_delivery_line_id;