DBA Data[Home] [Help]

APPS.OE_BULK_VALIDATE dependencies on FND_LOOKUP_TYPES

Line 469: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV

465: FROM OE_HEADERS_IFACE_ALL b
466: WHERE batch_id = p_batch_id and
467: b.demand_class_code IS NOT NULL and
468: NOT EXISTS (SELECT FLV.LOOKUP_CODE
469: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV
470: WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE
471: and FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
472: and FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
473: and FLV.LANGUAGE = userenv('LANG')

Line 527: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV

523: FROM OE_HEADERS_IFACE_ALL
524: WHERE batch_id = p_batch_id)
525: AND b.demand_class_code IS NOT NULL and
526: NOT EXISTS (SELECT FLV.LOOKUP_CODE
527: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV
528: WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE
529: and FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
530: and FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
531: and FLV.LANGUAGE = userenv('LANG')