2905: rctl.line_number
2906: into x_ref_invoice_number,
2907: x_ref_invoice_line_number
2908: from ra_customer_trx rct,
2909: ra_customer_trx_lines_all rctl
2910: where rctl.customer_trx_line_id = p_reference_cust_trx_line_id
2911: and rctl.customer_trx_id = rct.customer_trx_id;
2912:
2913: ELSE
2958:
2959: select /* MOAC_SQL_CHANGE */ rct.trx_number
2960: into l_credit_invoice_number
2961: from ra_customer_trx rct,
2962: ra_customer_trx_lines_all rctl
2963: where rctl.customer_trx_line_id = p_credit_invoice_line_id
2964: and rctl.customer_trx_id = rct.customer_trx_id;
2965:
2966: END IF;