eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_PRICE_ADJUST_COMP dependencies on OE_PRICE_ADJUSTMENTS

Line 486: FROM OE_PRICE_ADJUSTMENTS

482: ,x_header_adj_rec.OPERAND_PER_PQTY
483: ,x_header_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
484: -- ,x_header_adj_rec.INVOICED_AMOUNT
485: ,x_header_adj_rec.LOCK_CONTROL
486: FROM OE_PRICE_ADJUSTMENTS
487: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
488: and HEADER_ID = p_header_id AND LINE_ID IS NULL ;
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN

Line 2945: from oe_price_adjustments

2941: and list_line_type_code <> 'FREIGHT_CHARGE'
2942: and list_header_id IS NOT NULL -- it will be null for TAX and COST
2943: union
2944: SELECT price_adjustment_id
2945: from oe_price_adjustments
2946: where header_id=p_header_id
2947: and list_line_type_code <> 'FREIGHT_CHARGE'
2948: and list_header_id IS NOT NULL
2949: and line_id is null;

Line 3537: FROM OE_PRICE_ADJUSTMENTS

3533: ,x_line_adj_rec.OPERAND_PER_PQTY
3534: ,x_line_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
3535: -- ,x_line_adj_rec.INVOICED_AMOUNT
3536: ,x_line_adj_rec.LOCK_CONTROL
3537: FROM OE_PRICE_ADJUSTMENTS
3538: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3539: and header_ID = p_header_id
3540: AND LINE_ID IS NOT NULL;
3541: EXCEPTION

Line 6149: from oe_price_adjustments

6145: and list_header_id IS NOT NULL
6146: and version_number in (p_prior_version,p_current_version,p_next_version)
6147: union
6148: SELECT price_adjustment_id,line_id
6149: from oe_price_adjustments
6150: where header_id=p_header_id
6151: and list_line_type_code <> 'FREIGHT_CHARGE'
6152: and list_header_id IS NOT NULL
6153: and line_id is not null;