[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM mtl_item_categories MTC,
mtl_default_category_sets MTDCS,
mtl_category_set_valid_cats MCSV,
mtl_categories MC
WHERE MTDCS.functional_area_id = 7
AND MTC.category_set_id = MTDCS.category_set_id
AND MTC.inventory_item_id = TO_CHAR( p_inv_item_id )
AND MCSV.category_set_id = MTC.category_set_id
AND MCSV.category_id = MTC.category_id
AND MCSV.category_id = MC.category_id
AND p_pricing_date < nvl(MC.disable_date, p_pricing_date+1)
AND MTC.organization_id = NVL(p_orgid, MTC.organization_id)
AND MTC.category_id = to_number(p_ent_val);
SELECT NULL
INTO L_Dummy
FROM oe_transaction_types
WHERE transaction_type_id = p_order_type_id
AND ((ENFORCE_LINE_PRICES_FLAG = 'Y'
AND
P_Discounting_Privilege = 'UNLIMITED')
OR
ENFORCE_LINE_PRICES_FLAG = 'N')
AND ROWNUM = 1;
SELECT price_adjustment_id
INTO l_price_adjustment_id
FROM OE_PRICE_ADJUSTMENTS
WHERE HEADER_ID = P_HEADER_ID
AND LINE_ID = P_LINE_ID
AND NVL( AUTOMATIC_FLAG, 'N' ) = 'N'
AND (list_line_type_code = 'DIS'
OR list_line_type_code = 'SUR')
AND ROWNUM = 1;
SELECT NVL( SUM( NVL( Adjusted_amount, 0) ), 0)
INTO l_adjustment_total
FROM oe_price_adjustments
WHERE header_id = p_header_id
AND ((p_apply_order_adjs_flag = 'Y'
AND line_id IS NULL)
OR
(line_id = p_line_id
AND automatic_flag = 'Y'));