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.INV_MGD_MVT_FIN_MDTR dependencies on OE_PRICE_ADJUSTMENTS

Line 342: FROM oe_price_adjustments

338: AND rat.org_id = ratt.org_id
339: AND ratt.type NOT IN ('CM','DM')
340: AND NOT EXISTS
341: (SELECT null
342: FROM oe_price_adjustments
343: WHERE (line_id = oola.line_id
344: OR (line_id IS NULL AND modifier_level_code = 'ORDER'))
345: AND TO_CHAR(price_adjustment_id)= NVL(ratl.interface_line_attribute11, '-9999')
346: AND header_id = oola.header_id)

Line 369: FROM oe_price_adjustments

365: AND rat.org_id = ratt.org_id
366: AND ((ratt.type IN ('CM','DM'))
367: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
368: IN (SELECT TO_CHAR(price_adjustment_id)
369: FROM oe_price_adjustments
370: WHERE header_id = oola.header_id
371: AND (line_id = oola.line_id
372: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
373: AND ratl.line_type = 'LINE'

Line 451: FROM oe_price_adjustments

447: AND rat.org_id = ratt.org_id
448: AND ratt.type NOT IN ('CM','DM')
449: AND NOT EXISTS
450: (SELECT null
451: FROM oe_price_adjustments
452: WHERE (line_id = oola.line_id
453: OR (line_id IS NULL AND modifier_level_code = 'ORDER'))
454: AND TO_CHAR(price_adjustment_id)= NVL(ratl.interface_line_attribute11, '-9999')
455: AND header_id = oola.header_id)

Line 479: FROM oe_price_adjustments

475: AND rat.org_id = ratt.org_id
476: AND ((ratt.type IN ('CM','DM'))
477: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
478: IN (SELECT TO_CHAR(price_adjustment_id)
479: FROM oe_price_adjustments
480: WHERE header_id = oola.header_id
481: AND (line_id = oola.line_id
482: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
483: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'

Line 807: oe_price_adjustments

803: IS
804: SELECT
805: SUM(NVL(ADJUSTED_AMOUNT_PER_PQTY,0))
806: FROM
807: oe_price_adjustments
808: WHERE line_id = p_line_id
809: AND modifier_level_code = 'LINE'
810: AND list_line_type_code = 'FREIGHT_CHARGE';
811:

Line 917: FROM oe_price_adjustments

913: AND rat.org_id = ratt.org_id
914: AND ratt.type NOT IN ('CM','DM')
915: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
916: NOT IN (SELECT TO_CHAR(price_adjustment_id)
917: FROM oe_price_adjustments
918: WHERE header_id = p_movement_transaction.order_header_id
919: AND (line_id = l_line_id
920: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
921: AND ratl.line_type = 'LINE'

Line 2020: --Can use oe_price_adjustments.adjusted_amount_per_pqty to calculate total

2016: l_order_freight_charge_to_line := 0;
2017: END IF;
2018:
2019: --Freight charge2: line level freight charge
2020: --Can use oe_price_adjustments.adjusted_amount_per_pqty to calculate total
2021: --line charge for this line.
2022: --Comment out following code, because the line charge is calculated and
2023: --returned from the call of Calc_Total_Line_Charge
2024: /*Calc_Total_Line_Charge

Line 2158: FROM oe_price_adjustments

2154: AND rat.org_id = ratt.org_id
2155: AND ratt.type NOT IN ('CM','DM')
2156: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2157: NOT IN (SELECT TO_CHAR(price_adjustment_id)
2158: FROM oe_price_adjustments
2159: WHERE header_id = l_movement_transaction.order_header_id
2160: AND (line_id = l_movement_transaction.order_line_id
2161: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
2162: AND ratl.line_type = 'LINE'

Line 2210: FROM oe_price_adjustments

2206: AND rat.org_id = ratt.org_id
2207: AND ((ratt.type IN ('CM','DM'))
2208: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2209: IN (SELECT TO_CHAR(price_adjustment_id)
2210: FROM oe_price_adjustments
2211: WHERE header_id = l_movement_transaction.order_header_id
2212: AND (line_id = l_movement_transaction.order_line_id
2213: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
2214: AND ratl.line_type = 'LINE' --yawang

Line 2261: FROM oe_price_adjustments

2257: AND rat.org_id = ratt.org_id
2258: AND ratt.type NOT IN ('CM','DM')
2259: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2260: NOT IN (SELECT TO_CHAR(price_adjustment_id)
2261: FROM oe_price_adjustments
2262: WHERE header_id = l_movement_transaction.order_header_id
2263: AND (line_id = l_movement_transaction.order_line_id
2264: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
2265: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'

Line 2289: FROM oe_price_adjustments

2285: AND rat.org_id = ratt.org_id
2286: AND ((ratt.type IN ('CM','DM'))
2287: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2288: IN (SELECT TO_CHAR(price_adjustment_id)
2289: FROM oe_price_adjustments
2290: WHERE header_id = l_movement_transaction.order_header_id
2291: AND (line_id = l_movement_transaction.order_line_id
2292: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
2293: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'