The following lines contain the word 'select', 'insert', 'update' or 'delete':
select map_type into i_map_type
from ece_mappings
where map_id = i_map_id
and enabled ='Y';
ec_utils.g_stack.DELETE;
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
);
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;
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';
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;
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;
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
AND status = 'A'; --12645675 - Condition to check if the Site Usage is Active;
SELECT site_use_id
INTO l_site_use_id
From oe_invoice_to_orgs_v
WHERE address_id = p_address_id
AND status = 'A' --12645675 - Condition to check if the Site Usage is Active
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;
SELECT MEANING
INTO l_transaction_type
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_txn_code
AND LOOKUP_TYPE = 'ONT_ELECMSGS_TYPES';
EXECUTE IMMEDIATE 'Begin SELECT OE_XML_MESSAGE_SEQ_S.nextval INTO :1 FROM DUAL; end;'
SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
INTO l_org_id
FROM DUAL;
l_parameter_list.delete;
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;
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;
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 ;
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 ;
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;
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 ;