DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on RA_CUSTOMER_TRX_LINES_ALL

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 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 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