APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on OE_PRICE_ADJUSTMENTS

Line 491: ' from oe_price_adjustments p '||

487: ' sum(decode(p.list_line_type_code, ''FREIGHT_CHARGE'', '||
488: ' decode(nvl(p.applied_flag, ''Y''), ''Y'', '||
489: ' decode(p.arithmetic_operator, ''LUMPSUM'', null, p.adjusted_amount), '||
490: ' null), null)) charge_adjamt '||
491: ' from oe_price_adjustments p '||
492: ' where p.line_id is not null '||
493: ' and p.charge_type_code in (''FTECHARGE'', ''FTEPRICE'') '||
494: ' group by p.line_id) opa '||
495: ' WHERE nvl(l.order_firmed_date, h.booked_date) >= to_date('''|| l_from_date || ''',''MM/DD/YYYY HH24:MI:SS'')'||

Line 810: from oe_price_adjustments p,

806: FROM (select p.line_id, sum(decode(p.list_line_type_code, 'COST',
807: p.adjusted_amount, null)) cost,
808: sum(decode(p.list_line_type_code, 'FREIGHT_CHARGE', decode(nvl(p.applied_flag, 'Y'), 'Y', decode(p.arithmetic_operator, 'LUMPSUM', p.operand, null), null), null)) charge_operand,
809: sum(decode(p.list_line_type_code, 'FREIGHT_CHARGE', decode(nvl(p.applied_flag, 'Y'), 'Y', decode(p.arithmetic_operator, 'LUMPSUM', null, p.adjusted_amount), null), null)) charge_adjamt
810: from oe_price_adjustments p,
811: (select /*+ no_merge cardinality (log, 1000)*/ distinct line_id from isc_dbi_change_log log) log1
812: where p.line_id = log1.line_id
813: and p.line_id is not null
814: and p.charge_type_code in ('FTEPRICE', 'FTECHARGE')