APPS.OE_DEFAULT_HEADER SQL Statements

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

Line: 36

              SELECT freight_code
              INTO   l_freight_code
              FROM   wsh_carriers wsh_ca,wsh_carrier_services wsh,
                     wsh_org_carrier_services wsh_org
              WHERE  wsh_org.organization_id      = p_header_rec.ship_from_org_id
              AND    wsh.carrier_service_id       = wsh_org.carrier_service_id
              AND    wsh_ca.carrier_id            = wsh.carrier_id
              AND    wsh.ship_method_code         = p_header_rec.shipping_method_code
              AND    wsh_org.enabled_flag         = 'Y';

Line: 46

              SELECT FREIGHT_CODE
              INTO   l_freight_code
              FROM   wsh_carrier_ship_methods
              WHERE  ship_method_code = p_header_rec.shipping_method_code
              AND    ORGANIZATION_ID = p_header_rec.ship_from_org_id;

Line: 116

     Select order_category_code
     into l_category_code
     from
     oe_order_types_v
     where
     order_type_id = p_header_rec.order_type_id;

Line: 123

	IF p_header_rec.operation = oe_globals.g_opr_update THEN
	IF (p_old_header_rec.order_category_code <> FND_API.G_MISS_CHAR AND
		   p_old_header_rec.order_category_code IS NOT NULL ) THEN
		IF NOT OE_GLOBALS.EQUAL(p_old_header_rec.order_category_code,
	       	l_category_code) THEN
                         FND_MESSAGE.SET_NAME('ONT','OE_ORD_CAT_CONST');

Line: 173

Select  SHIP_SETS_INCLUDE_LINES_FLAG,
ARRIVALSETS_INCLUDE_LINES_FLAG
from hz_cust_accounts
where
cust_account_id = p_header_rec.sold_to_org_id;

Line: 179

Select  SHIP_SETS_INCLUDE_LINES_FLAG,
ARRIVALSETS_INCLUDE_LINES_FLAG
from hz_cust_site_uses
where
site_use_id = lsiteuseid;

Line: 338

 * Select from the sequence
 *
 */
    SELECT  OE_ORDER_HEADERS_S.NEXTVAL
    INTO    l_hdr_id
    FROM    DUAL;

Line: 466

  SELECT  ORDER_SOURCE_ID
    INTO  l_order_source_id
    FROM  OE_ORDER_SOURCES
   WHERE name = 'Online';

Line: 497

   SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL
     INTO l_em_message_id
     FROM DUAL;

Line: 525

      select contract_template_id
      into l_contract_template_id
      from oe_order_types_v
      where order_type_id = p_header_rec.order_type_id;

Line: 670

    SELECT BH.ORDER_NUMBER
    INTO l_blanket_number
    FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
    WHERE     BH.CUST_PO_NUMBER = p_cust_po_number
        AND   BH.SOLD_TO_ORG_ID = p_sold_to_org_id
        AND   BHE.ON_HOLD_FLAG = 'N'
        AND   trunc(nvl(l_request_date,sysdate))
        BETWEEN trunc(BHE.START_DATE_ACTIVE)
        AND   trunc(nvl(BHE.END_DATE_ACTIVE, nvl(l_request_date,sysdate)))
        AND   BH.ORDER_NUMBER = BHE.ORDER_NUMBER
        AND   BH.SALES_DOCUMENT_TYPE_CODE = 'B';

Line: 861

        SELECT 'Y'
        INTO   l_exists
        FROM   oe_def_condn_elems
        WHERE  value_string = 'ORGANIZATION'
        AND    attribute_code = 'PARTY_TYPE'
        AND    rownum = 1;

Line: 873

          SELECT party.party_type
          INTO   l_party_type
          FROM   hz_cust_accounts cust_acct,
                 hz_parties party
          WHERE  party.party_id = cust_acct.party_id
          AND    cust_acct.cust_account_id = g_header_rec.sold_to_org_id;

Line: 1221

	-- If expiration date is changing, update time component to midnight
        -- i.e. to 23:59:59
        IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.expiration_date
                           ,p_old_header_rec.expiration_date)
	THEN
	   p_x_header_rec.expiration_date :=
	        trunc(p_x_header_rec.expiration_date,'DD') +
                                          ((24*60*60)-1)/(24*60*60);