APPS.OE_OE_FORM_LINE dependencies on RA_CUSTOMER_TRX_ALL

Line 3663: from ra_customer_trx_all rct,

3659: select /* MOAC_SQL_CHANGE */ rct.trx_number,
3660: rctl.line_number
3661: into x_line_val_rec.ref_invoice_number,
3662: x_line_val_rec.ref_invoice_line_number
3663: from ra_customer_trx_all rct,
3664: ra_customer_trx_lines_all rctl
3665: where rctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
3666: and rctl.customer_trx_id = rct.customer_trx_id;
3667: EXCEPTION

Line 3683: from ra_customer_trx_all rct,

3679: select /* MOAC_SQL_CHANGE */ rct.trx_number,
3680: rctl.line_number
3681: into x_line_val_rec.ref_invoice_number,
3682: x_line_val_rec.ref_invoice_line_number
3683: from ra_customer_trx_all rct,
3684: ra_customer_trx_lines_all rctl
3685: where rctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
3686: and rctl.customer_trx_id = rct.customer_trx_id;
3687: EXCEPTION

Line 3701: from ra_customer_trx_all rct,

3697: IF (p_line_rec.credit_invoice_line_id is not null) THEN
3698: BEGIN
3699: select /* MOAC_SQL_CHANGE */ rct.trx_number
3700: into x_line_val_rec.credit_invoice_number
3701: from ra_customer_trx_all rct,
3702: ra_customer_trx_lines_all rctl
3703: where rctl.customer_trx_line_id = p_line_rec.credit_invoice_line_id
3704: and rctl.customer_trx_id = rct.customer_trx_id;
3705: EXCEPTION