[Home] [Help]
1931: | NOTES |
1932: | |
1933: | MODIFICATION HISTORY |
1934: | 10-NOV-95 Charlie Tomberg Created |
1935: | 12-JAN-01 Michael Raymond Fixed select over ra_interface_lines
1936: | table to properly test trx_type
1937: | for commitment invoices. OM
1938: | is using a little-known method where
1939: | the trx_type is defaulted from the
1941: | See bug 1580737 for details.
1942: | 11-APR-01 Michael Raymond Implemented promised_commitment_amount
1943: | and allocate_tax_freight logic for
1944: | commitment-related lines in
1945: | ra_interface_lines table.
1946: | See bugs 1483656 and 1645425 for details.
1947: +===========================================================================*/
1948:
1949: FUNCTION calc_commitment_balance( p_customer_trx_id IN Number,
2040: SELECT NVL( l_commitment_bal, 0 ) -
2041: NVL( SUM(NVL(i.promised_commitment_amount,
2042: i.amount)), 0)
2043: INTO l_commitment_bal
2044: FROM ra_interface_lines i,
2045: ra_customer_trx_lines l
2046: WHERE NVL(interface_status,
2047: 'A') <> 'P'
2048: AND (i.line_type = 'LINE'