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 774: oe_price_adjustments

770: IS
771: SELECT
772: SUM(NVL(ADJUSTED_AMOUNT_PER_PQTY,0))
773: FROM
774: oe_price_adjustments
775: WHERE line_id = p_line_id
776: AND modifier_level_code = 'LINE'
777: AND list_line_type_code = 'FREIGHT_CHARGE';
778:

Line 884: FROM oe_price_adjustments

880: AND rat.org_id = ratt.org_id
881: AND ratt.type NOT IN ('CM','DM')
882: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
883: NOT IN (SELECT TO_CHAR(price_adjustment_id)
884: FROM oe_price_adjustments
885: WHERE header_id = p_movement_transaction.order_header_id
886: AND (line_id = l_line_id
887: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
888: AND ratl.line_type = 'LINE'

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

1897: l_order_freight_charge_to_line := 0;
1898: END IF;
1899:
1900: --Freight charge2: line level freight charge
1901: --Can use oe_price_adjustments.adjusted_amount_per_pqty to calculate total
1902: --line charge for this line.
1903: --Comment out following code, because the line charge is calculated and
1904: --returned from the call of Calc_Total_Line_Charge
1905: /*Calc_Total_Line_Charge

Line 2039: FROM oe_price_adjustments

2035: AND rat.org_id = ratt.org_id
2036: AND ratt.type NOT IN ('CM','DM')
2037: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2038: NOT IN (SELECT TO_CHAR(price_adjustment_id)
2039: FROM oe_price_adjustments
2040: WHERE header_id = l_movement_transaction.order_header_id
2041: AND (line_id = l_movement_transaction.order_line_id
2042: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
2043: AND ratl.line_type = 'LINE'

Line 2091: FROM oe_price_adjustments

2087: AND rat.org_id = ratt.org_id
2088: AND ((ratt.type IN ('CM','DM'))
2089: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2090: IN (SELECT TO_CHAR(price_adjustment_id)
2091: FROM oe_price_adjustments
2092: WHERE header_id = l_movement_transaction.order_header_id
2093: AND (line_id = l_movement_transaction.order_line_id
2094: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
2095: AND ratl.line_type = 'LINE' --yawang

Line 2122: FROM oe_price_adjustments

2118: AND rat.org_id = ratt.org_id
2119: AND ratt.type NOT IN ('CM','DM')
2120: AND NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2121: NOT IN (SELECT TO_CHAR(price_adjustment_id)
2122: FROM oe_price_adjustments
2123: WHERE header_id = l_movement_transaction.order_header_id
2124: AND (line_id = l_movement_transaction.order_line_id
2125: OR (line_id IS NULL AND modifier_level_code = 'ORDER')))
2126: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'

Line 2150: FROM oe_price_adjustments

2146: AND rat.org_id = ratt.org_id
2147: AND ((ratt.type IN ('CM','DM'))
2148: OR (NVL(ratl.interface_line_attribute11, '-9999') --Fix bug 2423946
2149: IN (SELECT TO_CHAR(price_adjustment_id)
2150: FROM oe_price_adjustments
2151: WHERE header_id = l_movement_transaction.order_header_id
2152: AND (line_id = l_movement_transaction.order_line_id
2153: OR (line_id IS NULL AND modifier_level_code = 'ORDER')) )))
2154: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'