DBA Data[Home] [Help]

APPS.OE_OE_TOTALS_SUMMARY dependencies on OE_PAYMENTS

Line 623: FROM oe_payments op

619: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
620: -- Select the committment applied amount if Commitment Sequencing "On"
621: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))
622: INTO l_commitment_total
623: FROM oe_payments op
624: WHERE op.header_id = p_header_id
625: AND NOT EXISTS
626: (SELECT 'Non Invoiceable Item Line'
627: FROM mtl_system_items mti, oe_order_lines_all ool