APPS.OE_VERSION_PRICE_ADJUST_COMP dependencies on OE_PRICE_ADJS_HISTORY

Line 233: FROM OE_PRICE_ADJS_HISTORY

229: ,x_header_adj_rec.OPERAND_PER_PQTY
230: ,x_header_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
231: -- ,x_header_adj_rec.INVOICED_AMOUNT
232: ,x_header_adj_rec.LOCK_CONTROL
233: FROM OE_PRICE_ADJS_HISTORY
234: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
235: and HEADER_ID = p_header_id
236: AND LINE_ID IS NULL
237: and version_number = p_version

Line 2936: from oe_price_adjs_history

2932: IS
2933:
2934: CURSOR C_get_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
2935: SELECT distinct price_adjustment_id
2936: from oe_price_adjs_history
2937: where header_id = p_header_id
2938: and line_id is null
2939: --and phase_change_flag = p_transaction_phase_code
2940: and version_number in (p_prior_version,p_current_version,p_next_version)

Line 2954: from oe_price_adjs_history

2950: --and transaction_phase_code = p_transaction_phase_code;
2951:
2952: CURSOR C_get_hist_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
2953: SELECT distinct price_adjustment_id
2954: from oe_price_adjs_history
2955: where header_id = p_header_id
2956: and line_id is null
2957: and list_line_type_code <> 'FREIGHT_CHARGE'
2958: and list_header_id IS NOT NULL

Line 3283: FROM OE_PRICE_ADJS_HISTORY

3279: ,x_line_adj_rec.OPERAND_PER_PQTY
3280: ,x_line_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
3281: -- ,x_line_adj_rec.INVOICED_AMOUNT
3282: ,x_line_adj_rec.LOCK_CONTROL
3283: FROM OE_PRICE_ADJS_HISTORY
3284: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3285: and header_ID = p_header_id
3286: and version_number = p_version
3287: AND LINE_ID IS NOT NULL

Line 6140: from oe_price_adjs_history

6136: IS
6137:
6138: CURSOR C_get_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
6139: SELECT distinct price_adjustment_id,line_id
6140: from oe_price_adjs_history
6141: where header_id = p_header_id
6142: and line_id is not null
6143: --and phase_change_flag = p_transaction_phase_code
6144: and list_line_type_code <> 'FREIGHT_CHARGE'

Line 6158: from oe_price_adjs_history

6154: --and transaction_phase_code = p_transaction_phase_code;
6155:
6156: CURSOR C_get_hist_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
6157: SELECT distinct price_adjustment_id,line_id
6158: from oe_price_adjs_history
6159: where header_id = p_header_id
6160: and line_id is not null
6161: and list_line_type_code <> 'FREIGHT_CHARGE'
6162: and list_header_id IS NOT NULL