The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT mc.concatenated_segments CATEGORY,
msi.concatenated_segments ITEM,
cppb.inventory_item_id INVENTORY_ITEM_ID,
cppb.txn_category,
ml.meaning STEP,
round (nvl(cppb.txn_category_qty,0), :p_qty_precision) CATEGORY_QUANTITY,
round (nvl(cppb.period_quantity, 0), :p_qty_precision) CUMULATIVE_QUANTITY,
round (sum (nvl(cppb.periodic_cost,0)), 2) PERIODIC_COST,
round (sum (nvl(cppb.txn_category_value,0)), 2) AMOUNT,
round (sum (nvl(cppb.period_balance,0)), 2) CAV,
round (sum (nvl(cppb.variance_amount,0)), 2) VARIANCE_AMOUNT
FROM cst_pac_period_balances cppb
, mfg_lookups ml
, mtl_item_categories mic
, mtl_categories_kfv mc
, mtl_system_items_kfv msi
WHERE CPPB.cost_group_id = :p_cost_group_id
AND CPPB.pac_period_id = :p_pac_period_id
AND CPPB.inventory_item_id = MSI.inventory_item_id
AND ml.lookup_type = ''CST_PAC_TXN_CATEGORY''
/* The MFG LOOKUP exhibits inconsistent behavior with fractional number
as lookup code. To ensure that the txn category is between 2 and 3 but
also use the mfg lookup for meaning mfg lookup has been seeded with 11
for txn_category 2.5 */
AND ml.lookup_code = decode(cppb.txn_category,2.5,11,cppb.txn_category)
AND mic.inventory_item_id = cppb.inventory_item_id
AND mic.organization_id = :p_item_master_org_id
AND mic.category_set_id = :p_category_set_id
AND mc.category_id = mic.category_id
AND msi.organization_id = mic.organization_id
AND msi.inventory_item_id = cppb.inventory_item_id
AND msi.concatenated_segments between
nvl(:p_item_from, msi.concatenated_segments)
AND nvl(:p_item_to, msi.concatenated_segments)
AND mc.concatenated_segments between
nvl(:p_category_from, mc.concatenated_segments)
AND nvl(:p_category_to, mc.concatenated_segments)
GROUP BY mc.concatenated_segments,
msi.concatenated_segments,
cppb.inventory_item_id,
CPPB.txn_category,
ml.meaning,
cppb.txn_category_qty,
cppb.period_quantity
ORDER BY mc.concatenated_segments, msi.concatenated_segments, cppb.txn_category'
USING p_qty_precision, p_qty_precision, p_cost_group_id, p_pac_period_id,
p_item_master_org_id, p_category_set_id, p_item_from, p_item_to,
p_category_from, p_category_to;
SELECT name
INTO l_legal_entity
FROM xle_entity_profiles
WHERE legal_entity_id = i_legal_entity_id;
SELECT cost_type
INTO l_cost_type
FROM cst_cost_types
WHERE cost_type_id = i_cost_type_id;
SELECT cost_group
INTO l_cost_group
FROM cst_cost_groups
WHERE cost_group_id = i_cost_group_id
AND cost_group_type = 2;
SELECT period_name
INTO l_pac_period
FROM cst_pac_periods
WHERE pac_period_id = i_pac_period_id
AND legal_entity = i_legal_entity_id
AND cost_type_id = i_cost_type_id;
SELECT category_set_name
INTO l_category_set
FROM mtl_category_sets
WHERE category_set_id = i_category_set_id;
SELECT organization_code
INTO l_item_master_org
FROM mtl_parameters
WHERE organization_id = i_item_master_org_id;
SELECT currency_code
INTO l_currency_code
FROM gl_ledger_le_v
WHERE legal_entity_id = i_legal_entity_id
AND ledger_category_code = 'PRIMARY';
'SELECT :l_legal_entity LEGAL_ENTITY,
:l_cost_type COST_TYPE,
:l_pac_period PAC_PERIOD,
:l_cost_group COST_GROUP,
:l_category_set CATEGORY_SET,
:l_item_master_org ITEM_MASTER_ORG,
:i_category_from CATEGORY_FROM,
:i_category_to CATEGORY_TO,
:i_item_from ITEM_FROM,
:i_item_to ITEM_TO,
:l_currency_code CURRENCY_CODE
FROM dual'
USING l_legal_entity, l_cost_type, l_pac_period, l_cost_group,
l_category_set, l_item_master_org, i_category_from, i_category_to,
i_item_from, i_item_to, l_currency_code;