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_INVOICE_PUB dependencies on OE_PRICE_ADJUSTMENTS

Line 4623: FROM OE_PRICE_ADJUSTMENTS D

4619: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4620: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839
4621: AND DIS.INTERFACE_LINE_ATTRIBUTE11 =
4622: (SELECT D.PRICE_ADJUSTMENT_ID
4623: FROM OE_PRICE_ADJUSTMENTS D
4624: WHERE D.HEADER_ID = l_ref_header_id
4625: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
4626: AND D.APPLIED_FLAG = 'Y' -- 3630426 Added for Retrobilling
4627: AND D.LIST_LINE_ID =

Line 4629: FROM OE_PRICE_ADJUSTMENTS D2

4625: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
4626: AND D.APPLIED_FLAG = 'Y' -- 3630426 Added for Retrobilling
4627: AND D.LIST_LINE_ID =
4628: (SELECT D2.LIST_LINE_ID
4629: FROM OE_PRICE_ADJUSTMENTS D2
4630: WHERE D2.PRICE_ADJUSTMENT_ID = L_DISCOUNTS_REC.INTERFACE_LINE_ATTRIBUTE11));
4631:
4632: EXCEPTION
4633: WHEN OTHERS THEN

Line 4747: UPDATE OE_PRICE_ADJUSTMENTS

4743: oe_debug_pub.add('Charges Amount '||p_adjusted_amount);
4744: oe_debug_pub.add('Invoiced Amount'||p_invoiced_amount);
4745:
4746: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4747: UPDATE OE_PRICE_ADJUSTMENTS
4748: SET INVOICED_FLAG = 'Y'
4749: , INVOICED_AMOUNT = nvl(invoiced_amount,0) + p_invoiced_amount -- update with unrounded amount, for bug# 5400517
4750: , LOCK_CONTROL = LOCK_CONTROL + 1
4751: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line 4754: /*UPDATE OE_PRICE_ADJUSTMENTS

4750: , LOCK_CONTROL = LOCK_CONTROL + 1
4751: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
4752:
4753: --bug 4760069
4754: /*UPDATE OE_PRICE_ADJUSTMENTS
4755: SET UPDATED_FLAG = 'Y'
4756: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
4757: AND line_id IS NOT NULL;*/
4758:

Line 4761: UPDATE OE_PRICE_ADJUSTMENTS

4757: AND line_id IS NOT NULL;*/
4758:
4759: l_Header_Adj_tbl(1).Invoiced_Amount := nvl(l_Header_Adj_tbl(1).Invoiced_Amount, 0)+p_invoiced_amount;
4760: Else
4761: UPDATE OE_PRICE_ADJUSTMENTS
4762: SET INVOICED_FLAG = 'Y'
4763: , UPDATED_FLAG = 'Y'
4764: , LOCK_CONTROL = LOCK_CONTROL + 1
4765: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line 5044: FROM OE_PRICE_ADJUSTMENTS D

5040: AND FRE.INTERFACE_LINE_ATTRIBUTE1 = l_ref_order_number
5041: AND FRE.INTERFACE_LINE_ATTRIBUTE2 = l_ref_order_type
5042: AND FRE.INTERFACE_LINE_ATTRIBUTE6 =
5043: (SELECT TO_CHAR(D.PRICE_ADJUSTMENT_ID)
5044: FROM OE_PRICE_ADJUSTMENTS D
5045: WHERE D.HEADER_ID = l_ref_header_id
5046: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
5047: AND D.LIST_LINE_ID =
5048: (SELECT D2.LIST_LINE_ID

Line 5049: FROM OE_PRICE_ADJUSTMENTS D2

5045: WHERE D.HEADER_ID = l_ref_header_id
5046: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
5047: AND D.LIST_LINE_ID =
5048: (SELECT D2.LIST_LINE_ID
5049: FROM OE_PRICE_ADJUSTMENTS D2
5050: WHERE D2.PRICE_ADJUSTMENT_ID=p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE6));
5051:
5052: EXCEPTION
5053: WHEN OTHERS THEN

Line 8015: FROM oe_price_adjustments p

8011: /* BEGIN
8012: IF oe_code_control.code_release_level < '110510' then
8013: SELECT count(*)
8014: INTO l_freight_count
8015: FROM oe_price_adjustments p
8016: WHERE p.header_id = p_line_rec.header_id
8017: AND (p.line_id IS NULL OR p.line_id = p_line_rec.line_id)
8018: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8019: AND p.applied_flag = 'Y'

Line 8024: FROM oe_price_adjustments p

8020: AND NVL(p.invoiced_flag, 'N') = 'N';
8021: ELSE
8022: SELECT count(*)
8023: INTO l_freight_count
8024: FROM oe_price_adjustments p
8025: WHERE p.header_id = p_line_rec.header_id
8026: AND p.line_id IS NULL
8027: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8028: AND p.applied_flag = 'Y'

Line 8033: FROM oe_price_adjustments p

8029: AND (NVL(p.invoiced_flag, 'N') = 'N' OR (NVL(p.invoiced_flag, 'N') = 'Y' AND p.adjusted_amount <> nvl(p.invoiced_amount, p.adjusted_amount)));
8030: IF l_freight_count = 0 then
8031: SELECT count(*)
8032: INTO l_freight_count
8033: FROM oe_price_adjustments p
8034: WHERE p.header_id = p_line_rec.header_id
8035: AND p.line_id = p_line_rec.line_id
8036: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8037: AND p.applied_flag = 'Y'

Line 8137: FROM oe_price_adjustments p

8133:
8134: IF oe_code_control.code_release_level < '110510' then
8135: SELECT count(*)
8136: INTO l_freight_count
8137: FROM oe_price_adjustments p
8138: WHERE p.header_id = p_line_rec.header_id
8139: AND (p.line_id IS NULL OR p.line_id = p_line_rec.line_id)
8140: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8141: AND p.applied_flag = 'Y'

Line 8146: FROM oe_price_adjustments p

8142: AND NVL(p.invoiced_flag, 'N') = 'N';
8143: ELSE
8144: SELECT count(*)
8145: INTO l_freight_count
8146: FROM oe_price_adjustments p
8147: WHERE p.header_id = p_line_rec.header_id
8148: AND p.line_id IS NULL
8149: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8150: AND p.applied_flag = 'Y'

Line 8155: FROM oe_price_adjustments p

8151: AND (NVL(p.invoiced_flag, 'N') = 'N' OR (NVL(p.invoiced_flag, 'N') = 'Y' AND p.adjusted_amount <> nvl(p.invoiced_amount, p.adjusted_amount)));
8152: IF l_freight_count = 0 then
8153: SELECT count(*)
8154: INTO l_freight_count
8155: FROM oe_price_adjustments p
8156: WHERE p.header_id = p_line_rec.header_id
8157: AND p.line_id = p_line_rec.line_id
8158: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8159: AND p.applied_flag = 'Y'

Line 8690: FROM oe_price_adjustments p

8686: BEGIN
8687: IF oe_code_control.code_release_level < '110510' then
8688: SELECT count(*)
8689: INTO l_freight_count
8690: FROM oe_price_adjustments p
8691: WHERE p.header_id = l_line_rec.header_id
8692: AND (p.line_id IS NULL OR p.line_id = l_line_rec.line_id)
8693: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8694: AND p.applied_flag = 'Y'

Line 8699: FROM oe_price_adjustments p

8695: AND NVL(p.invoiced_flag, 'N') = 'N';
8696: ELSE
8697: SELECT count(*)
8698: INTO l_freight_count
8699: FROM oe_price_adjustments p
8700: WHERE p.header_id = l_line_rec.header_id
8701: AND p.line_id IS NULL
8702: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8703: AND p.applied_flag = 'Y'

Line 8708: FROM oe_price_adjustments p

8704: AND (NVL(p.invoiced_flag, 'N') = 'N' OR (NVL(p.invoiced_flag, 'N') = 'Y' AND p.adjusted_amount <> nvl(p.invoiced_amount, p.adjusted_amount)));
8705: IF l_freight_count = 0 then
8706: SELECT count(*)
8707: INTO l_freight_count
8708: FROM oe_price_adjustments p
8709: WHERE p.header_id = l_line_rec.header_id
8710: AND p.line_id = l_line_rec.line_id
8711: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8712: AND p.applied_flag = 'Y'

Line 8814: FROM oe_price_adjustments p

8810: BEGIN
8811: IF oe_code_control.code_release_level < '110510' then
8812: SELECT count(*)
8813: INTO l_freight_count
8814: FROM oe_price_adjustments p
8815: WHERE p.header_id = l_line_rec.header_id
8816: AND (p.line_id IS NULL OR p.line_id = l_line_rec.line_id)
8817: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8818: AND p.applied_flag = 'Y'

Line 8823: FROM oe_price_adjustments p

8819: AND NVL(p.invoiced_flag, 'N') = 'N';
8820: ELSE
8821: SELECT count(*)
8822: INTO l_freight_count
8823: FROM oe_price_adjustments p
8824: WHERE p.header_id = l_line_rec.header_id
8825: AND p.line_id IS NULL
8826: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8827: AND p.applied_flag = 'Y'

Line 8832: FROM oe_price_adjustments p

8828: AND (NVL(p.invoiced_flag, 'N') = 'N' OR (NVL(p.invoiced_flag, 'N') = 'Y' AND p.adjusted_amount <> nvl(p.invoiced_amount, p.adjusted_amount)));
8829: IF l_freight_count = 0 then
8830: SELECT count(*)
8831: INTO l_freight_count
8832: FROM oe_price_adjustments p
8833: WHERE p.header_id = l_line_rec.header_id
8834: AND p.line_id = l_line_rec.line_id
8835: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8836: AND p.applied_flag = 'Y'