[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM MTL_SYSTEM_ITEMS_INTERFACE
WHERE ((organization_id = org_id) OR (all_Org = 1))
AND set_process_id = xset_id
AND process_flag in (31, 32, 33, 34 , 35 , 45);
SELECT FUNCTIONAL_AREA_DESC, mcs.category_set_name
FROM mtl_category_sets_vl mcs
,mtl_default_category_sets_fk_v mdcs
WHERE mcs.category_set_id = mdcs.category_set_id
AND mcs.default_category_id IS NULL
AND mdcs.functional_area_id = cp_farea_id; --Bug 4654433
SELECT 'x'
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = cp_lookup_type
AND LOOKUP_CODE = cp_lookup_code
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND ENABLED_FLAG = 'Y';
SELECT 'x'
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = cp_lookup_type
AND LOOKUP_CODE = cp_lookup_code
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND ENABLED_FLAG = 'Y';
SELECT 'x'
FROM ZX_OUTPUT_CLASSIFICATIONS_V
WHERE lookup_code = cp_tax_code
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND org_id IN (-99,(SELECT org_information3 FROM hr_organization_information
WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
AND ORGANIZATION_ID=cp_org_id));
SELECT functional_area_id
FROM mtl_default_category_sets dcs
,mtl_category_sets_b cs
WHERE cs.category_set_id = dcs.category_set_id
AND cs.default_category_id IS NULL
AND dcs.functional_area_id IN (1,2,3,4,5,6,7,9,10);
select inventory_item_id into l_item_id
from mtl_system_items_interface
where transaction_id = cr.transaction_id
and set_process_id = xset_id; */
select count(*) into temp_count
from MRP_PLANNING_EXCEPTION_SETS
where EXCEPTION_SET_NAME = cr.PLANNING_EXCEPTION_SET;
select 'x' into temp
from MTL_ATP_RULES
where RULE_ID = cr.ATP_RULE_ID;
select 'x' into temp
from MTL_SYSTEM_ITEMS_B
where INVENTORY_ITEM_ID = cr.BASE_WARRANTY_SERVICE_ID
and ORGANIZATION_ID = cr.ORGANIZATION_ID;
select 'x' into temp
from RA_TERMS
where TERM_ID = cr.PAYMENT_TERMS_ID;
select master_organization_id
into masterorg_id
from mtl_parameters
where organization_id = cr.organization_id ;
select 'x' into temp
from MTL_UNITS_OF_MEASURE muom1
where muom1.UNIT_OF_MEASURE = cr.UNIT_OF_ISSUE
and muom1.UOM_CLASS in
(select UOM_CLASS
from MTL_UNITS_OF_MEASURE muom2
where muom2.UNIT_OF_MEASURE = cr.PRIMARY_UNIT_OF_MEASURE);
select 'x' into temp
from mtl_item_uoms_view
where organization_id = masterorg_id
and inventory_item_id = cr.inventory_item_id
and unit_of_measure = cr.unit_of_issue ;
select 'x' into temp
from mtl_item_uoms_view
where organization_id = cr.organization_id
and inventory_item_id = cr.inventory_item_id
and unit_of_measure = cr.unit_of_issue ;
select 'x' into temp
from MTL_PARAMETERS
where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID;
select 'x' into temp
from org_organization_definitions
where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
and nvl(disable_date,sysdate+1) > sysdate;
select 'x' into temp
from MTL_PARAMETERS
where ORGANIZATION_ID = cr.DEFAULT_SHIPPING_ORG;
select 'x' into temp
from RA_RULES
where RULE_ID = cr.ACCOUNTING_RULE_ID
and TYPE not in ('I')
and STATUS = 'A';
select 'x' into temp
from RA_RULES
where RULE_ID = cr.INVOICING_RULE_ID;
select 'x' into temp
from MTL_PLANNERS
where PLANNER_CODE = cr.PLANNER_CODE
and ORGANIZATION_ID = cr.ORGANIZATION_ID
and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
select 'x' into temp
from hr_organization_information
where org_information_context = 'Customer/Supplier Association'
and (org_information1 is not null or org_information3 is not null)
and organization_id = cr.organization_id;
** for all the updates that CSTFVSUB does to MSII.
*/
IF l_inv_debug_level IN(101, 102) THEN
INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');
INVPUTLI.info('INVPPROC.inproit_process_item: Checking Default categories before insert');
/* NP26DEC94 : New code to update process_flag.
** This code necessiated due to the breaking up INVPVHDR into
** 6 smaller packages to overcome PL/SQL limitations
** with code size.
** Let's update the process flag for the record
** Give it value 42 if all okay and 32 if some
** validation failed in this procedure
** Need to do this ONLY if all previous validation okay.
** The process flag values that are possible at this time are
** 31 :set by INVPVHDR
** 32 :set by INVPVDR2
** 33 :set by INVPVDR3
** 34 :set by INVPVDR4
** 35, 45 :set by INVPVDR5
** 36, 46 :set by INVPVDR7
*/
/* Bug 4705184
select process_flag into temp_proc_flag
from MTL_SYSTEM_ITEMS_INTERFACE
where inventory_item_id = l_item_id
and set_process_id + 0 = xset_id
and process_flag in (31, 32, 33, 34, 35, 45)
and organization_id = cr.organization_id
and rownum < 2; */
update MTL_SYSTEM_ITEMS_INTERFACE
set process_flag = DECODE(status,0,46,36),
PRIMARY_UOM_CODE = cr.primary_uom_code,
primary_unit_of_measure = cr.primary_unit_of_measure
where inventory_item_id = l_item_id
and set_process_id + 0 = xset_id
and process_flag = 45
and organization_id = cr.organization_id;