[Home] [Help]
1844: | NOTES |
1845: | |
1846: | MODIFICATION HISTORY |
1847: | 10-NOV-95 Charlie Tomberg Created |
1848: | 12-JAN-01 Michael Raymond Fixed select over ra_interface_lines
1849: | table to properly test trx_type
1850: | for commitment invoices. OM
1851: | is using a little-known method where
1852: | the trx_type is defaulted from the
1854: | See bug 1580737 for details.
1855: | 11-APR-01 Michael Raymond Implemented promised_commitment_amount
1856: | and allocate_tax_freight logic for
1857: | commitment-related lines in
1858: | ra_interface_lines table.
1859: | See bugs 1483656 and 1645425 for details.
1860: +===========================================================================*/
1861:
1862: FUNCTION calc_commitment_balance( p_customer_trx_id IN Number,
1953: SELECT NVL( l_commitment_bal, 0 ) -
1954: NVL( SUM(NVL(i.promised_commitment_amount,
1955: i.amount)), 0)
1956: INTO l_commitment_bal
1957: FROM ra_interface_lines i,
1958: ra_customer_trx_lines l
1959: WHERE NVL(interface_status,
1960: 'A') <> 'P'
1961: AND (i.line_type = 'LINE'