APPS.OE_OE_FORM_LINE dependencies on FND_GLOBAL

Line 3353: and SECURITY_GROUP_ID =fnd_global.Lookup_Security_Group(lv.lookup_type,lv.view_application_id);

3349: and((lookup_code= shipment_priority_code
3350: and lookup_type='SHIPMENT_PRIORITY')
3351: or (lookup_code=freight_terms_code
3352: and lookup_type='FREIGHT_TERMS'))
3353: and SECURITY_GROUP_ID =fnd_global.Lookup_Security_Group(lv.lookup_type,lv.view_application_id);
3354: /*l_organization_id Number:=fnd_profile.value('OE_ORGANIZATION_ID');*/
3355: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
3356: l_organization_id Number;
3357: /* Need to Change Exception Handling- Not Sure whether we should continue

Line 3795: fnd_global.Lookup_Security_Group(lv.lookup_type,

3791: AND lookup_code = p_line_rec.flow_status_code
3792: AND LANGUAGE = userenv('LANG')
3793: AND VIEW_APPLICATION_ID = 660
3794: AND SECURITY_GROUP_ID =
3795: fnd_global.Lookup_Security_Group(lv.lookup_type,
3796: lv.view_application_id);
3797:
3798: status is AWAITING_SHIPPING or PRODUCTION_COMPLETE etc.
3799: get value from shipping table

Line 3819: fnd_global.Lookup_Security_Group(lv.lookup_type,

3815: AND lookup_code = 'PICKED'
3816: AND LANGUAGE = userenv('LANG')
3817: AND VIEW_APPLICATION_ID = 660
3818: AND SECURITY_GROUP_ID =
3819: fnd_global.Lookup_Security_Group(lv.lookup_type,
3820: lv.view_application_id);
3821:
3822: ELSIF released_count < total_count and released_count <> 0 THEN
3823: SELECT meaning

Line 3831: fnd_global.Lookup_Security_Group(lv.lookup_type,

3827: AND lookup_code = 'PICKED_PARTIAL'
3828: AND LANGUAGE = userenv('LANG')
3829: AND VIEW_APPLICATION_ID = 660
3830: AND SECURITY_GROUP_ID =
3831: fnd_global.Lookup_Security_Group(lv.lookup_type,
3832: lv.view_application_id);
3833: ELSE
3834: SELECT meaning
3835: INTO l_flow_meaning

Line 3842: fnd_global.Lookup_Security_Group(lv.lookup_type,

3838: AND lookup_code = l_status
3839: AND LANGUAGE = userenv('LANG')
3840: AND VIEW_APPLICATION_ID = 660
3841: AND SECURITY_GROUP_ID =
3842: fnd_global.Lookup_Security_Group(lv.lookup_type,
3843: lv.view_application_id);
3844: END IF;
3845: END IF;
3846: x_line_val_rec.status:= l_flow_meaning;