DBA Data[Home] [Help]

APPS.OE_LINE_STATUS_PUB dependencies on FND_LOOKUP_VALUES

Line 811: FROM fnd_lookup_values lv

807: l_flow_status_code <> 'PO_RECEIVED'
808: THEN
809: SELECT meaning
810: INTO l_flow_meaning
811: FROM fnd_lookup_values lv
812: WHERE lookup_type = 'LINE_FLOW_STATUS'
813: AND lookup_code = l_flow_status_code
814: AND LANGUAGE = userenv('LANG')
815: AND VIEW_APPLICATION_ID = 660

Line 837: FROM fnd_lookup_values lv

833:
834: IF released_count = total_count THEN
835: SELECT meaning
836: INTO l_flow_meaning
837: FROM fnd_lookup_values lv
838: WHERE lookup_type = 'LINE_FLOW_STATUS'
839: AND lookup_code = 'PICKED'
840: AND LANGUAGE = userenv('LANG')
841: AND VIEW_APPLICATION_ID = 660

Line 849: FROM fnd_lookup_values lv

845:
846: ELSIF released_count < total_count and released_count <> 0 THEN
847: SELECT meaning
848: INTO l_flow_meaning
849: FROM fnd_lookup_values lv
850: WHERE lookup_type = 'LINE_FLOW_STATUS'
851: AND lookup_code = 'PICKED_PARTIAL'
852: AND LANGUAGE = userenv('LANG')
853: AND VIEW_APPLICATION_ID = 660

Line 860: FROM fnd_lookup_values lv

856: lv.view_application_id);
857: ELSE
858: SELECT meaning
859: INTO l_flow_meaning
860: FROM fnd_lookup_values lv
861: WHERE lookup_type = 'LINE_FLOW_STATUS'
862: AND lookup_code = l_flow_status_code
863: AND LANGUAGE = userenv('LANG')
864: AND VIEW_APPLICATION_ID = 660