575: ) *
576: NVL( selling_price, 0 )
577: ), 0 )
578: INTO l_uninv_commitment_bal
579: FROM so_lines
580: WHERE commitment_id = p_customer_trx_id
581: AND line_type_code IN ( 'REGULAR', 'DETAIL');
582:
583: