APPS.OE_OE_FORM_LINE dependencies on RA_CUSTOMER_TRX

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 3664: ra_customer_trx_lines_all rctl

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
3668: WHEN NO_DATA_FOUND THEN

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 3684: ra_customer_trx_lines_all rctl

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
3688: WHEN NO_DATA_FOUND THEN

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

Line 3702: ra_customer_trx_lines_all rctl

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
3706: WHEN NO_DATA_FOUND THEN

Line 4460: from ra_customer_trx

4456: IF (p_line_rec.commitment_id is not null) THEN
4457: BEGIN
4458: select trx_number
4459: into x_line_val_rec.commitment
4460: from ra_customer_trx
4461: where customer_trx_id=p_line_rec.commitment_id;
4462:
4463:
4464: EXCEPTION