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 4854: FROM OE_PRICE_ADJUSTMENTS D

4850: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4851: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839
4852: AND DIS.INTERFACE_LINE_ATTRIBUTE11 =
4853: (SELECT D.PRICE_ADJUSTMENT_ID
4854: FROM OE_PRICE_ADJUSTMENTS D
4855: WHERE D.HEADER_ID = l_ref_header_id
4856: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
4857: AND D.APPLIED_FLAG = 'Y' -- 3630426 Added for Retrobilling
4858: AND D.LIST_LINE_ID =

Line 4860: FROM OE_PRICE_ADJUSTMENTS D2

4856: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
4857: AND D.APPLIED_FLAG = 'Y' -- 3630426 Added for Retrobilling
4858: AND D.LIST_LINE_ID =
4859: (SELECT D2.LIST_LINE_ID
4860: FROM OE_PRICE_ADJUSTMENTS D2
4861: WHERE D2.PRICE_ADJUSTMENT_ID = L_DISCOUNTS_REC.INTERFACE_LINE_ATTRIBUTE11));
4862:
4863: EXCEPTION
4864: WHEN OTHERS THEN

Line 4978: UPDATE OE_PRICE_ADJUSTMENTS

4974: oe_debug_pub.add('Charges Amount '||p_adjusted_amount);
4975: oe_debug_pub.add('Invoiced Amount'||p_invoiced_amount);
4976:
4977: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4978: UPDATE OE_PRICE_ADJUSTMENTS
4979: SET INVOICED_FLAG = 'Y'
4980: , INVOICED_AMOUNT = nvl(invoiced_amount,0) + p_invoiced_amount -- update with unrounded amount, for bug# 5400517
4981: , LOCK_CONTROL = LOCK_CONTROL + 1
4982: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line 4985: /*UPDATE OE_PRICE_ADJUSTMENTS

4981: , LOCK_CONTROL = LOCK_CONTROL + 1
4982: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
4983:
4984: --bug 4760069
4985: /*UPDATE OE_PRICE_ADJUSTMENTS
4986: SET UPDATED_FLAG = 'Y'
4987: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
4988: AND line_id IS NOT NULL;*/
4989:

Line 4992: UPDATE OE_PRICE_ADJUSTMENTS

4988: AND line_id IS NOT NULL;*/
4989:
4990: l_Header_Adj_tbl(1).Invoiced_Amount := nvl(l_Header_Adj_tbl(1).Invoiced_Amount, 0)+p_invoiced_amount;
4991: Else
4992: UPDATE OE_PRICE_ADJUSTMENTS
4993: SET INVOICED_FLAG = 'Y'
4994: , UPDATED_FLAG = 'Y'
4995: , LOCK_CONTROL = LOCK_CONTROL + 1
4996: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line 5288: FROM OE_PRICE_ADJUSTMENTS D

5284: AND FRE.INTERFACE_LINE_ATTRIBUTE1 = l_ref_order_number
5285: AND FRE.INTERFACE_LINE_ATTRIBUTE2 = l_ref_order_type
5286: AND FRE.INTERFACE_LINE_ATTRIBUTE6 =
5287: (SELECT TO_CHAR(D.PRICE_ADJUSTMENT_ID)
5288: FROM OE_PRICE_ADJUSTMENTS D
5289: WHERE D.HEADER_ID = l_ref_header_id
5290: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
5291: AND D.LIST_LINE_ID =
5292: (SELECT D2.LIST_LINE_ID

Line 5293: FROM OE_PRICE_ADJUSTMENTS D2

5289: WHERE D.HEADER_ID = l_ref_header_id
5290: AND NVL(D.LINE_ID, l_ref_line_id) = l_ref_line_id
5291: AND D.LIST_LINE_ID =
5292: (SELECT D2.LIST_LINE_ID
5293: FROM OE_PRICE_ADJUSTMENTS D2
5294: WHERE D2.PRICE_ADJUSTMENT_ID=p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE6));
5295:
5296: EXCEPTION
5297: WHEN OTHERS THEN

Line 8401: FROM oe_price_adjustments p

8397: /* BEGIN
8398: IF oe_code_control.code_release_level < '110510' then
8399: SELECT count(*)
8400: INTO l_freight_count
8401: FROM oe_price_adjustments p
8402: WHERE p.header_id = p_line_rec.header_id
8403: AND (p.line_id IS NULL OR p.line_id = p_line_rec.line_id)
8404: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8405: AND p.applied_flag = 'Y'

Line 8410: FROM oe_price_adjustments p

8406: AND NVL(p.invoiced_flag, 'N') = 'N';
8407: ELSE
8408: SELECT count(*)
8409: INTO l_freight_count
8410: FROM oe_price_adjustments p
8411: WHERE p.header_id = p_line_rec.header_id
8412: AND p.line_id IS NULL
8413: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8414: AND p.applied_flag = 'Y'

Line 8419: FROM oe_price_adjustments p

8415: 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)));
8416: IF l_freight_count = 0 then
8417: SELECT count(*)
8418: INTO l_freight_count
8419: FROM oe_price_adjustments p
8420: WHERE p.header_id = p_line_rec.header_id
8421: AND p.line_id = p_line_rec.line_id
8422: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8423: AND p.applied_flag = 'Y'

Line 8532: FROM oe_price_adjustments p

8528:
8529: IF oe_code_control.code_release_level < '110510' then
8530: SELECT count(*)
8531: INTO l_freight_count
8532: FROM oe_price_adjustments p
8533: WHERE p.header_id = p_line_rec.header_id
8534: AND (p.line_id IS NULL OR p.line_id = p_line_rec.line_id)
8535: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8536: AND p.applied_flag = 'Y'

Line 8542: FROM oe_price_adjustments p

8538: AND NVL(p_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
8539: ELSE
8540: SELECT count(*)
8541: INTO l_freight_count
8542: FROM oe_price_adjustments p
8543: WHERE p.header_id = p_line_rec.header_id
8544: AND p.line_id IS NULL
8545: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8546: AND p.applied_flag = 'Y'

Line 8552: FROM oe_price_adjustments p

8548: AND NVL(p_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
8549: IF l_freight_count = 0 then
8550: SELECT count(*)
8551: INTO l_freight_count
8552: FROM oe_price_adjustments p
8553: WHERE p.header_id = p_line_rec.header_id
8554: AND p.line_id = p_line_rec.line_id
8555: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8556: AND p.applied_flag = 'Y'

Line 9230: FROM oe_price_adjustments p

9226: BEGIN
9227: IF oe_code_control.code_release_level < '110510' then
9228: SELECT count(*)
9229: INTO l_freight_count
9230: FROM oe_price_adjustments p
9231: WHERE p.header_id = l_line_rec.header_id
9232: AND (p.line_id IS NULL OR p.line_id = l_line_rec.line_id)
9233: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9234: AND p.applied_flag = 'Y'

Line 9240: FROM oe_price_adjustments p

9236: AND NVL(l_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
9237: ELSE
9238: SELECT count(*)
9239: INTO l_freight_count
9240: FROM oe_price_adjustments p
9241: WHERE p.header_id = l_line_rec.header_id
9242: AND p.line_id IS NULL
9243: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9244: AND p.applied_flag = 'Y'

Line 9250: FROM oe_price_adjustments p

9246: AND NVL(l_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
9247: IF l_freight_count = 0 then
9248: SELECT count(*)
9249: INTO l_freight_count
9250: FROM oe_price_adjustments p
9251: WHERE p.header_id = l_line_rec.header_id
9252: AND p.line_id = l_line_rec.line_id
9253: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9254: AND p.applied_flag = 'Y'

Line 9365: FROM oe_price_adjustments p

9361: BEGIN
9362: IF oe_code_control.code_release_level < '110510' then
9363: SELECT count(*)
9364: INTO l_freight_count
9365: FROM oe_price_adjustments p
9366: WHERE p.header_id = l_line_rec.header_id
9367: AND (p.line_id IS NULL OR p.line_id = l_line_rec.line_id)
9368: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9369: AND p.applied_flag = 'Y'

Line 9375: FROM oe_price_adjustments p

9371: AND NVL(l_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
9372: ELSE
9373: SELECT count(*)
9374: INTO l_freight_count
9375: FROM oe_price_adjustments p
9376: WHERE p.header_id = l_line_rec.header_id
9377: AND p.line_id IS NULL
9378: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9379: AND p.applied_flag = 'Y'

Line 9385: FROM oe_price_adjustments p

9381: AND NVL(l_line_rec.service_bill_option_code,'FBOM')='FBOM'; --sol_ord_er #16014165
9382: IF l_freight_count = 0 then
9383: SELECT count(*)
9384: INTO l_freight_count
9385: FROM oe_price_adjustments p
9386: WHERE p.header_id = l_line_rec.header_id
9387: AND p.line_id = l_line_rec.line_id
9388: AND p.list_line_type_code = 'FREIGHT_CHARGE'
9389: AND p.applied_flag = 'Y'