APPS.ECEPOI SQL Statements

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

Line: 43

	select map_type into i_map_type
        from ece_mappings
        where map_id = i_map_id
          and enabled ='Y';

Line: 72

	ec_utils.g_stack.DELETE;

Line: 89

            argument4   => 'INSERT',-- Operation code = INSERT
            argument5   => 'N',	-- Validate_Only = 'N'
            argument6   => '1',	-- Debug Level = 1
            argument7   => i_num_instances -- No. of Instance to run for OIMP
			);

Line: 164

 select su.org_id into l_orgid
    from hz_cust_acct_sites st, hz_cust_site_uses_all su
    where    st.cust_acct_site_id = p_address_id
    and      su.cust_acct_site_id = st.cust_acct_site_id
    and su.site_use_code= 'SHIP_TO' and rownum =1;

Line: 171

    SELECT site_use_id
    INTO   l_site_use_id
    FROM   oe_ship_to_orgs_v
    WHERE  customer_id = p_customer_id
    AND    address_id  = p_address_id
    AND    status = 'A';

Line: 178

    SELECT site_use_id
    INTO   l_site_use_id
    From   oe_ship_to_orgs_v
    WHERE  address_id  = p_address_id
    AND    status = 'A' AND
    customer_id in (
                    Select p_customer_id from dual
                    union
                    select cust_account_id from
                    hz_cust_acct_relate_all where
                    related_cust_account_id = p_customer_id)
    and rownum = 1;

Line: 208

 select su.org_id into l_orgid
    from hz_cust_acct_sites st, hz_cust_site_uses_all su
    where    st.cust_acct_site_id = p_address_id
    and      su.cust_acct_site_id = st.cust_acct_site_id
    and su.site_use_code= 'BILL_TO' and rownum =1;

Line: 215

    SELECT site_use_id
    INTO   l_site_use_id
    FROM   oe_invoice_to_orgs_v
    WHERE  customer_id = p_customer_id
    AND    address_id  = p_address_id;

Line: 221

    SELECT site_use_id
    INTO   l_site_use_id
    From   oe_invoice_to_orgs_v
    WHERE  address_id  = p_address_id
    AND
    customer_id in (
                    Select p_customer_id from dual
                    union
                    select cust_account_id from
                    hz_cust_acct_relate_all where
                    related_cust_account_id = p_customer_id)
    and rownum = 1;

Line: 269

    SELECT  MEANING
    INTO    l_transaction_type
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_txn_code
    AND     LOOKUP_TYPE = 'ONT_ELECMSGS_TYPES';

Line: 347

  EXECUTE IMMEDIATE 'Begin  SELECT OE_XML_MESSAGE_SEQ_S.nextval INTO :1 FROM DUAL; end;'

Line: 421

     SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
            NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
       INTO l_org_id
       FROM DUAL;

Line: 460

  l_parameter_list.delete;

Line: 496

         SELECT description
         INTO   x_item_description
         FROM   mtl_system_items_vl
         WHERE  inventory_item_id = p_inventory_item_id
         AND    organization_id = l_organization_id;

Line: 506

	SELECT citems.customer_item_desc
	INTO   l_item_description
	FROM   mtl_customer_items citems
	WHERE  citems.customer_item_id = p_ordered_item_id
        AND    citems.customer_id = p_sold_to_org_id;

Line: 513

	      SELECT sitems.description
	      INTO   l_item_description
	      FROM   mtl_system_items_vl sitems
	      WHERE  sitems.inventory_item_id = p_inventory_item_id
  	      AND    sitems.organization_id = l_organization_id ;

Line: 524

     SELECT sitems.description
     INTO   x_item_description
     FROM   mtl_system_items_vl sitems
     WHERE  sitems.inventory_item_id = p_inventory_item_id
     AND    sitems.organization_id = l_organization_id ;

Line: 530

         SELECT NVL(items.description, sitems.description)
         INTO   x_item_description
         FROM   mtl_cross_reference_types types
              , mtl_cross_references items
              , mtl_system_items_vl sitems
         WHERE  types.cross_reference_type = items.cross_reference_type
         AND    items.inventory_item_id = sitems.inventory_item_id
         AND    sitems.organization_id = l_organization_id
         AND    sitems.inventory_item_id = p_inventory_item_id
         AND    items.cross_reference_type = p_item_identifier_type
         AND    items.cross_reference = p_ordered_item -- check that how ordered_item_id can be used
         AND    ROWNUM = 1;

Line: 548

     SELECT sitems.description
     INTO   x_item_description
     FROM   mtl_system_items_vl sitems
     WHERE  sitems.inventory_item_id = p_inventory_item_id
     AND    sitems.organization_id = l_organization_id ;