DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 3763: ra_customer_trx_lines_all rctl

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

Line 3783: ra_customer_trx_lines_all rctl

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

Line 3801: ra_customer_trx_lines_all rctl

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