DBA Data[Home] [Help]

APPS.OE_OE_TOTALS_SUMMARY dependencies on OE_PAYMENTS

Line 604: FROM oe_payments op

600: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
601: -- Select the committment applied amount if Commitment Sequencing "On"
602: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))
603: INTO l_commitment_total
604: FROM oe_payments op
605: WHERE op.header_id = p_header_id
606: AND NOT EXISTS
607: (SELECT 'Non Invoiceable Item Line'
608: FROM mtl_system_items mti, oe_order_lines_all ool