APPS.OE_DEFAULT_LINE dependencies on AR_LOOKUPS

Line 2730: ar_lookups arlup

2726: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2727: INTO l_invoice_line_id
2728: FROM ra_customer_trx_lines_all rctl,
2729: ra_customer_trx rct,
2730: ar_lookups arlup
2731: WHERE rct.status_trx = arlup.lookup_code
2732: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2733: AND rct.customer_trx_id = rctl.customer_trx_id
2734: AND rctl.interface_line_context='ORDER ENTRY'

Line 2761: ar_lookups arlup

2757: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2758: INTO l_invoice_line_id
2759: FROM ra_customer_trx_lines_all rctl,
2760: ra_customer_trx rct,
2761: ar_lookups arlup
2762: WHERE rct.status_trx = arlup.lookup_code
2763: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2764: AND rct.customer_trx_id = rctl.customer_trx_id
2765: AND rctl.interface_line_context='ORDER ENTRY'

Line 3184: ar_lookups arlup

3180: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3181: INTO l_invoice_line_id
3182: FROM ra_customer_trx_lines_all rctl,
3183: ra_customer_trx rct,
3184: ar_lookups arlup
3185: WHERE rct.status_trx = arlup.lookup_code
3186: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3187: AND rct.customer_trx_id = rctl.customer_trx_id
3188: AND rctl.interface_line_context = 'ORDER ENTRY'

Line 3253: ar_lookups arlup

3249: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3250: INTO l_invoice_line_id
3251: FROM ra_customer_trx_lines_all rctl,
3252: ra_customer_trx rct,
3253: ar_lookups arlup
3254: WHERE rct.status_trx = arlup.lookup_code
3255: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3256: AND rct.customer_trx_id = rctl.customer_trx_id
3257: AND p_return_attribute2 = rctl.interface_line_attribute6