APPS.OE_OE_FORM_LINE dependencies on FND_GLOBAL

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

3416: and((lookup_code= shipment_priority_code
3417: and lookup_type='SHIPMENT_PRIORITY')
3418: or (lookup_code=freight_terms_code
3419: and lookup_type='FREIGHT_TERMS'))
3420: and SECURITY_GROUP_ID =fnd_global.Lookup_Security_Group(lv.lookup_type,lv.view_application_id);
3421: /*l_organization_id Number:=fnd_profile.value('OE_ORGANIZATION_ID');*/
3422: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
3423: l_organization_id Number;
3424: /* Need to Change Exception Handling- Not Sure whether we should continue

Line 3894: fnd_global.Lookup_Security_Group(lv.lookup_type,

3890: AND lookup_code = p_line_rec.flow_status_code
3891: AND LANGUAGE = userenv('LANG')
3892: AND VIEW_APPLICATION_ID = 660
3893: AND SECURITY_GROUP_ID =
3894: fnd_global.Lookup_Security_Group(lv.lookup_type,
3895: lv.view_application_id);
3896:
3897: status is AWAITING_SHIPPING or PRODUCTION_COMPLETE etc.
3898: get value from shipping table

Line 3918: fnd_global.Lookup_Security_Group(lv.lookup_type,

3914: AND lookup_code = 'PICKED'
3915: AND LANGUAGE = userenv('LANG')
3916: AND VIEW_APPLICATION_ID = 660
3917: AND SECURITY_GROUP_ID =
3918: fnd_global.Lookup_Security_Group(lv.lookup_type,
3919: lv.view_application_id);
3920:
3921: ELSIF released_count < total_count and released_count <> 0 THEN
3922: SELECT meaning

Line 3930: fnd_global.Lookup_Security_Group(lv.lookup_type,

3926: AND lookup_code = 'PICKED_PARTIAL'
3927: AND LANGUAGE = userenv('LANG')
3928: AND VIEW_APPLICATION_ID = 660
3929: AND SECURITY_GROUP_ID =
3930: fnd_global.Lookup_Security_Group(lv.lookup_type,
3931: lv.view_application_id);
3932: ELSE
3933: SELECT meaning
3934: INTO l_flow_meaning

Line 3941: fnd_global.Lookup_Security_Group(lv.lookup_type,

3937: AND lookup_code = l_status
3938: AND LANGUAGE = userenv('LANG')
3939: AND VIEW_APPLICATION_ID = 660
3940: AND SECURITY_GROUP_ID =
3941: fnd_global.Lookup_Security_Group(lv.lookup_type,
3942: lv.view_application_id);
3943: END IF;
3944: END IF;
3945: x_line_val_rec.status:= l_flow_meaning;