APPS.OE_LINE_STATUS_PUB dependencies on FND_GLOBAL

Line 817: fnd_global.Lookup_Security_Group(lv.lookup_type,

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

Line 843: fnd_global.Lookup_Security_Group(lv.lookup_type,

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

Line 855: fnd_global.Lookup_Security_Group(lv.lookup_type,

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

Line 866: fnd_global.Lookup_Security_Group(lv.lookup_type,

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