APPS.OE_OE_FORM_LINE dependencies on FND_LOOKUP_VALUES

Line 3413: FROM FND_LOOKUP_VALUES LV

3409: CURSOR c2(shipment_priority_code VARCHAR2,
3410: freight_terms_code VARCHAR2)
3411: IS
3412: SELECT meaning,lookup_type
3413: FROM FND_LOOKUP_VALUES LV
3414: WHERE LANGUAGE = userenv('LANG')
3415: and VIEW_APPLICATION_ID = 660
3416: and((lookup_code= shipment_priority_code
3417: and lookup_type='SHIPMENT_PRIORITY')

Line 3888: FROM fnd_lookup_values lv

3884: p_line_rec.flow_status_code <> 'PO_RECEIVED'
3885: THEN
3886: SELECT meaning
3887: INTO l_flow_meaning
3888: FROM fnd_lookup_values lv
3889: WHERE lookup_type = 'LINE_FLOW_STATUS'
3890: AND lookup_code = p_line_rec.flow_status_code
3891: AND LANGUAGE = userenv('LANG')
3892: AND VIEW_APPLICATION_ID = 660

Line 3912: FROM fnd_lookup_values lv

3908:
3909: IF released_count = total_count THEN
3910: SELECT meaning
3911: INTO l_flow_meaning
3912: FROM fnd_lookup_values lv
3913: WHERE lookup_type = 'LINE_FLOW_STATUS'
3914: AND lookup_code = 'PICKED'
3915: AND LANGUAGE = userenv('LANG')
3916: AND VIEW_APPLICATION_ID = 660

Line 3924: FROM fnd_lookup_values lv

3920:
3921: ELSIF released_count < total_count and released_count <> 0 THEN
3922: SELECT meaning
3923: INTO l_flow_meaning
3924: FROM fnd_lookup_values lv
3925: WHERE lookup_type = 'LINE_FLOW_STATUS'
3926: AND lookup_code = 'PICKED_PARTIAL'
3927: AND LANGUAGE = userenv('LANG')
3928: AND VIEW_APPLICATION_ID = 660

Line 3935: FROM fnd_lookup_values lv

3931: lv.view_application_id);
3932: ELSE
3933: SELECT meaning
3934: INTO l_flow_meaning
3935: FROM fnd_lookup_values lv
3936: WHERE lookup_type = 'LINE_FLOW_STATUS'
3937: AND lookup_code = l_status
3938: AND LANGUAGE = userenv('LANG')
3939: AND VIEW_APPLICATION_ID = 660