APPS.OE_DEFAULT_LINE dependencies on RA_CUSTOMER_TRX_LINES

Line 2847: FROM ra_customer_trx_lines_all rctl,

2843:
2844: IF l_order_line_id IS NOT NULL THEN
2845: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2846: INTO l_invoice_line_id
2847: FROM ra_customer_trx_lines_all rctl,
2848: ra_customer_trx rct,
2849: ar_lookups arlup
2850: WHERE rct.status_trx = arlup.lookup_code
2851: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'

Line 2878: FROM ra_customer_trx_lines_all rctl,

2874:
2875: BEGIN
2876: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2877: INTO l_invoice_line_id
2878: FROM ra_customer_trx_lines_all rctl,
2879: ra_customer_trx rct,
2880: ar_lookups arlup
2881: WHERE rct.status_trx = arlup.lookup_code
2882: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'

Line 3033: FROM ra_customer_trx_lines_all rctl,

3029: /* Modified the following query to put the ivoice currency check for the bug 6916542 */
3030:
3031: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
3032: INTO p_ref_line_id
3033: FROM ra_customer_trx_lines_all rctl,
3034: ra_customer_trx_all rct,
3035: oe_order_lines_all l,
3036: oe_order_headers h
3037: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id

Line 3301: FROM ra_customer_trx_lines_all rctl,

3297: END IF;
3298: BEGIN
3299: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3300: INTO l_invoice_line_id
3301: FROM ra_customer_trx_lines_all rctl,
3302: ra_customer_trx rct,
3303: ar_lookups arlup
3304: WHERE rct.status_trx = arlup.lookup_code
3305: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'

Line 3370: FROM ra_customer_trx_lines_all rctl,

3366: BEGIN
3367:
3368: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3369: INTO l_invoice_line_id
3370: FROM ra_customer_trx_lines_all rctl,
3371: ra_customer_trx rct,
3372: ar_lookups arlup
3373: WHERE rct.status_trx = arlup.lookup_code
3374: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'

Line 3474: FROM ra_customer_trx_lines rctl

3470: BEGIN
3471:
3472: SELECT to_number(rctl.interface_line_attribute6)
3473: INTO l_order_line_id
3474: FROM ra_customer_trx_lines rctl
3475: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id;
3476:
3477: RETURN l_order_line_id;
3478:

Line 3527: FROM ra_customer_trx_lines_all rctl,

3523: l_tax_exempt_flag,
3524: l_tax_exempt_reason_code,
3525: l_tax_exempt_number,
3526: l_uom_code
3527: FROM ra_customer_trx_lines_all rctl,
3528: oe_order_lines l
3529: WHERE rctl.customer_trx_line_id = p_invoice_line_id
3530: AND to_number(rctl.interface_line_attribute6) = l.line_id;
3531: EXCEPTION