APPS.WSH_ECE_VIEWS_DEF SQL Statements

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

Line: 36

  SELECT  DISTINCT
    contact.PHONE_AREA_CODE   Area_Code,
    contact.PHONE_NUMBER    Phone_Number
  INTO
    cont_area_code_x,
                WSH_ECE_VIEWS_DEF.cont_phone_number_x
  FROM HZ_CONTACT_POINTS    contact,
       HZ_CUST_ACCOUNT_ROLES      acct_roles
        WHERE  acct_roles.CUST_ACCOUNT_ROLE_ID  = contact_id_in
           AND contact.OWNER_TABLE_NAME   = 'HZ_PARTIES'
           AND acct_roles.PARTY_ID              = contact.owner_table_id(+)
           AND contact.CONTACT_POINT_TYPE   IN ( 'PHONE', 'FAX', 'TELEX')
           AND contact.PHONE_LINE_TYPE    = 'GEN'
           AND contact.PRIMARY_FLAG   = 'Y';

Line: 119

SELECT DISTINCT
       contact.PHONE_AREA_CODE   Area_Code,
       contact.PHONE_NUMBER    Phone_Number,
       hcar.cust_acct_site_id  acct_site_id
FROM   HZ_CONTACT_POINTS        contact,
       HZ_CUST_ACCOUNT_ROLES  hcar
WHERE  hcar.CUST_ACCOUNT_ID    = p_customer_id
AND    contact.CONTACT_POINT_TYPE       = 'PHONE'
AND    contact.PRIMARY_FLAG             = 'Y'
AND    contact.OWNER_TABLE_NAME   = 'HZ_PARTIES'
AND    contact.OWNER_TABLE_ID     =  hcar.PARTY_ID
AND    contact.PHONE_LINE_TYPE    = 'GEN'
AND    hcar.status = 'A'
order  by nvl(hcar.cust_acct_site_id,-99999);

Line: 231

       select lookup_code from oe_lookups where lookup_type
       = 'INVOICE_NUMBER_METHOD' and meaning = 'Delivery Name';

Line: 290

       SELECT item_type FROM mtl_system_items WHERE
       inventory_item_id = p_vehicle_item_id AND
       organization_id = p_vehicle_org_id AND
       vehicle_item_flag = 'Y' ;

Line: 356

       SELECT Name FROM ra_terms
       WHERE term_id = p_payment_term_id;

Line: 475

    SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES
    WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
    ORG_INDEPENDENT_FLAG = 'N' AND ORGANIZATION_ID = X_ORGANIZATION_ID;

Line: 480

    SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES
    WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
    ORG_INDEPENDENT_FLAG = 'Y';

Line: 541

procedure update_del_asn_info(X_DELIVERY_ID            IN     NUMBER,
                              X_TIME_STAMP_SEQUENCE_NUMBER        IN OUT NOCOPY  NUMBER,
                              X_TIME_STAMP_DATE        IN OUT NOCOPY  DATE,
                              X_G_TIME_STAMP_SEQUENCE_NUMBER IN OUT NOCOPY  NUMBER,
                              X_G_TIME_STAMP_DATE IN OUT NOCOPY  DATE) IS
                              --
l_debug_on BOOLEAN;

Line: 549

                              l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_DEL_ASN_INFO';

Line: 582

           SELECT wsh_asn_seq_number_s.nextval,
                  sysdate
             INTO X_G_TIME_STAMP_SEQUENCE_NUMBER,
                  X_G_TIME_STAMP_DATE
             FROM dual;

Line: 593

  UPDATE WSH_NEW_DELIVERIES
        SET asn_seq_number = X_G_TIME_STAMP_SEQUENCE_NUMBER,
            asn_date_sent  = X_G_TIME_STAMP_DATE
        WHERE delivery_id    = X_DELIVERY_ID;

Line: 649

SELECT CL.customer_id,
       CL.location,
       CL.tp_location_code_ext,
       ECH.tp_reference_ext1,
       ECH.tp_reference_ext2,
       CL.customer_name,
       CL.address1,
       CL.address2,
       CL.address3,
       CL.address4,
       CL.city,
       CL.postal_code,
       CL.country,
       CL.state,
       CL.province,
       CL.county,
       CL.address_id
FROM wsh_customer_locations_v CL , ece_tp_headers ECH
WHERE CL.tp_header_id    = ECH.tp_header_id (+) AND
      CL.wsh_location_id = p_location_id AND
      CL.site_use_status = 'A' AND
      CL.site_use_code   = 'SHIP_TO';

Line: 951

select substrb( REL_PARTY.PERSON_LAST_NAME,1,50) ,
       substrb( REL_PARTY.PERSON_FIRST_NAME,1,40),
       ORG_CONT.JOB_TITLE
from   HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
       HZ_RELATIONSHIPS REL,
       HZ_ORG_CONTACTS ORG_CONT,
       HZ_PARTIES REL_PARTY
WHERE  ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
AND    REL.PARTY_ID  = ACCT_ROLE.PARTY_ID
AND    ACCT_ROLE.ROLE_TYPE  = 'CONTACT'
AND    REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
AND    REL.SUBJECT_TABLE_NAME  = 'HZ_PARTIES'
AND    REL.OBJECT_TABLE_NAME  = 'HZ_PARTIES'
AND    REL.DIRECTIONAL_FLAG  = 'F'
AND    REL.SUBJECT_ID = REL_PARTY.PARTY_ID;