DBA Data[Home] [Help]

APPS.OE_BULK_VALIDATE dependencies on FND_LOOKUP_VALUES

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')

Line 2085: fnd_lookup_values

2081: AND a.order_source_id = h.order_source_id
2082: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2083: AND a.CHARGE_TYPE_CODE IS NOT NULL
2084: AND NOT EXISTS (SELECT 'Y'FROM
2085: fnd_lookup_values
2086: WHERE LOOKUP_CODE = a.charge_type_code and
2087: LANGUAGE = userenv('LANG') and
2088: VIEW_APPLICATION_ID = 665 and
2089: SECURITY_GROUP_ID = 0 and