APPS.OE_LINE_STATUS_PUB dependencies on FND_GLOBAL

Line 820: fnd_global.Lookup_Security_Group(lv.lookup_type,

816: AND lookup_code = l_flow_status_code
817: AND LANGUAGE = userenv('LANG')
818: AND VIEW_APPLICATION_ID = 660
819: AND SECURITY_GROUP_ID =
820: fnd_global.Lookup_Security_Group(lv.lookup_type,
821: lv.view_application_id);
822:
823: /* status is AWAITING_SHIPPING or PRODUCTION_COMPLETE etc.
824: get value from shipping table */

Line 846: fnd_global.Lookup_Security_Group(lv.lookup_type,

842: AND lookup_code = 'PICKED'
843: AND LANGUAGE = userenv('LANG')
844: AND VIEW_APPLICATION_ID = 660
845: AND SECURITY_GROUP_ID =
846: fnd_global.Lookup_Security_Group(lv.lookup_type,
847: lv.view_application_id);
848:
849: ELSIF released_count < total_count and released_count <> 0 THEN
850: SELECT meaning

Line 858: fnd_global.Lookup_Security_Group(lv.lookup_type,

854: AND lookup_code = 'PICKED_PARTIAL'
855: AND LANGUAGE = userenv('LANG')
856: AND VIEW_APPLICATION_ID = 660
857: AND SECURITY_GROUP_ID =
858: fnd_global.Lookup_Security_Group(lv.lookup_type,
859: lv.view_application_id);
860: ELSE
861: SELECT meaning
862: INTO l_flow_meaning

Line 869: fnd_global.Lookup_Security_Group(lv.lookup_type,

865: AND lookup_code = l_flow_status_code
866: AND LANGUAGE = userenv('LANG')
867: AND VIEW_APPLICATION_ID = 660
868: AND SECURITY_GROUP_ID =
869: fnd_global.Lookup_Security_Group(lv.lookup_type,
870: lv.view_application_id);
871: END IF;
872: END IF;
873: