APPS.AR_GTA_REPORTS_PKG dependencies on OE_PRICE_ADJUSTMENTS

Line 2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;

2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2193:

Line 2303: FROM oe_price_adjustments opa

2299: ra_customer_trx_lines rctl
2300: WHERE rctl.customer_trx_id=l_ar_header_id
2301: --Yao add to fix bug#8765631 to exclude discount line
2302: AND NOT EXISTS ( SELECT opa.list_line_type_code
2303: FROM oe_price_adjustments opa
2304: WHERE rctl.interface_line_context='ORDER ENTRY'
2305: AND opa.price_adjustment_id = rctl.interface_line_attribute11
2306: AND opa.list_line_type_code='DIS')
2307: AND EXISTS (SELECT

Line 2338: FROM oe_price_adjustments opa

2334: --Yao Zhang Add for bug#8605196 to support discount line
2335: --c_discount_lines used to query discount lines for ar transaction line.
2336: CURSOR c_discount_lines(l_line_id IN NUMBER) IS
2337: SELECT opa.price_adjustment_id
2338: FROM oe_price_adjustments opa
2339: WHERE opa.line_id = l_line_id
2340: AND opa.list_line_type_code = 'DIS';
2341:
2342: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

Line 2506: FROM oe_price_adjustments opa

2502: THEN
2503: BEGIN
2504: SELECT opa.list_line_type_code
2505: INTO l_adjustment_type
2506: FROM oe_price_adjustments opa
2507: WHERE opa.price_adjustment_id = l_price_adjustment_id;
2508: EXCEPTION
2509: WHEN no_data_found THEN
2510: CLOSE c_ar_lines;