APPS.OE_DEFAULT_LINE dependencies on AR_LOOKUPS

Line 2849: ar_lookups arlup

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'
2852: AND rct.customer_trx_id = rctl.customer_trx_id
2853: AND rctl.interface_line_context='ORDER ENTRY'

Line 2880: ar_lookups arlup

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'
2883: AND rct.customer_trx_id = rctl.customer_trx_id
2884: AND rctl.interface_line_context='ORDER ENTRY'

Line 3303: ar_lookups arlup

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'
3306: AND rct.customer_trx_id = rctl.customer_trx_id
3307: AND rctl.interface_line_context = 'ORDER ENTRY'

Line 3372: ar_lookups arlup

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'
3375: AND rct.customer_trx_id = rctl.customer_trx_id
3376: AND p_return_attribute2 = rctl.interface_line_attribute6