DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on FND_GLOBAL

Line 755: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)

751: AND ar.lookup_type(+) = 'CUSTOMER CLASS'
752: AND ar.lookup_code(+) = CA.customer_class_code
753: AND ar.LANGUAGE(+) = userenv('LANG')
754: and ar.VIEW_APPLICATION_ID(+) = 222
755: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)
756: AND CA.cust_account_id(+) = desig.customer_id
757: AND SU1.cust_acct_site_id = AS1.cust_acct_site_id(+)
758: AND AS1.party_site_id = PS1.party_site_id(+)
759: AND PS1.location_id = LOC1.location_id(+)

Line 1012: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)

1008: AND ar.lookup_code(+) = CA.customer_class_code
1009: -- bug2384395
1010: AND ar.LANGUAGE(+) = userenv('LANG')
1011: and ar.VIEW_APPLICATION_ID(+) = 222
1012: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)
1013: AND CA.cust_account_id(+) = desig.customer_id
1014: AND SU1.cust_acct_site_id = AS1.cust_acct_site_id(+)
1015: AND AS1.party_site_id = PS1.party_site_id(+)
1016: AND PS1.location_id = LOC1.location_id(+)

Line 1217: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)

1213: AND ar.lookup_code(+) = CA.customer_class_code
1214: -- bug2384395
1215: AND ar.LANGUAGE(+) = userenv('LANG')
1216: and ar.VIEW_APPLICATION_ID(+) = 222
1217: and ar.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('CUSTOMER CLASS', 222)
1218: AND CA.cust_account_id(+) = md.customer_id
1219: AND SU1.cust_acct_site_id = AS1.cust_acct_site_id(+)
1220: AND AS1.party_site_id = PS1.party_site_id(+)
1221: AND PS1.location_id = LOC1.location_id(+)