APPS.OE_OE_FORM_LINE dependencies on RA_CUSTOMER_TRX_ALL

Line 3762: from ra_customer_trx_all rct,

3758: select /* MOAC_SQL_CHANGE */ rct.trx_number,
3759: rctl.line_number
3760: into x_line_val_rec.ref_invoice_number,
3761: x_line_val_rec.ref_invoice_line_number
3762: from ra_customer_trx_all rct,
3763: ra_customer_trx_lines_all rctl
3764: where rctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
3765: and rctl.customer_trx_id = rct.customer_trx_id;
3766: EXCEPTION

Line 3782: from ra_customer_trx_all rct,

3778: select /* MOAC_SQL_CHANGE */ rct.trx_number,
3779: rctl.line_number
3780: into x_line_val_rec.ref_invoice_number,
3781: x_line_val_rec.ref_invoice_line_number
3782: from ra_customer_trx_all rct,
3783: ra_customer_trx_lines_all rctl
3784: where rctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
3785: and rctl.customer_trx_id = rct.customer_trx_id;
3786: EXCEPTION

Line 3800: from ra_customer_trx_all rct,

3796: IF (p_line_rec.credit_invoice_line_id is not null) THEN
3797: BEGIN
3798: select /* MOAC_SQL_CHANGE */ rct.trx_number
3799: into x_line_val_rec.credit_invoice_number
3800: from ra_customer_trx_all rct,
3801: ra_customer_trx_lines_all rctl
3802: where rctl.customer_trx_line_id = p_line_rec.credit_invoice_line_id
3803: and rctl.customer_trx_id = rct.customer_trx_id;
3804: EXCEPTION