APPS.OE_OE_FORM_LINE dependencies on FND_LOOKUP_VALUES

Line 3346: FROM FND_LOOKUP_VALUES LV

3342: CURSOR c2(shipment_priority_code VARCHAR2,
3343: freight_terms_code VARCHAR2)
3344: IS
3345: SELECT meaning,lookup_type
3346: FROM FND_LOOKUP_VALUES LV
3347: WHERE LANGUAGE = userenv('LANG')
3348: and VIEW_APPLICATION_ID = 660
3349: and((lookup_code= shipment_priority_code
3350: and lookup_type='SHIPMENT_PRIORITY')

Line 3789: FROM fnd_lookup_values lv

3785: p_line_rec.flow_status_code <> 'PO_RECEIVED'
3786: THEN
3787: SELECT meaning
3788: INTO l_flow_meaning
3789: FROM fnd_lookup_values lv
3790: WHERE lookup_type = 'LINE_FLOW_STATUS'
3791: AND lookup_code = p_line_rec.flow_status_code
3792: AND LANGUAGE = userenv('LANG')
3793: AND VIEW_APPLICATION_ID = 660

Line 3813: FROM fnd_lookup_values lv

3809:
3810: IF released_count = total_count THEN
3811: SELECT meaning
3812: INTO l_flow_meaning
3813: FROM fnd_lookup_values lv
3814: WHERE lookup_type = 'LINE_FLOW_STATUS'
3815: AND lookup_code = 'PICKED'
3816: AND LANGUAGE = userenv('LANG')
3817: AND VIEW_APPLICATION_ID = 660

Line 3825: FROM fnd_lookup_values lv

3821:
3822: ELSIF released_count < total_count and released_count <> 0 THEN
3823: SELECT meaning
3824: INTO l_flow_meaning
3825: FROM fnd_lookup_values lv
3826: WHERE lookup_type = 'LINE_FLOW_STATUS'
3827: AND lookup_code = 'PICKED_PARTIAL'
3828: AND LANGUAGE = userenv('LANG')
3829: AND VIEW_APPLICATION_ID = 660

Line 3836: FROM fnd_lookup_values lv

3832: lv.view_application_id);
3833: ELSE
3834: SELECT meaning
3835: INTO l_flow_meaning
3836: FROM fnd_lookup_values lv
3837: WHERE lookup_type = 'LINE_FLOW_STATUS'
3838: AND lookup_code = l_status
3839: AND LANGUAGE = userenv('LANG')
3840: AND VIEW_APPLICATION_ID = 660