APPS.OE_VALIDATE dependencies on OE_FND_COMMON_LOOKUPS_V

Line 1499: FROM OE_FND_COMMON_LOOKUPS_V

1495: END IF;
1496:
1497: SELECT 'VALID'
1498: INTO l_dummy
1499: FROM OE_FND_COMMON_LOOKUPS_V
1500: WHERE LOOKUP_CODE = p_demand_class_code
1501: AND LOOKUP_TYPE = l_lookup_type
1502: AND APPLICATION_ID = 700
1503: AND ENABLED_FLAG = 'Y'

Line 2041: FROM OE_FND_COMMON_LOOKUPS_V

2037: END IF;
2038:
2039: SELECT 'VALID'
2040: INTO l_dummy
2041: FROM OE_FND_COMMON_LOOKUPS_V
2042: WHERE LOOKUP_CODE = p_partial_shipments_allowed
2043: AND LOOKUP_TYPE = l_lookup_type
2044: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
2045: AND NVL(END_DATE_ACTIVE, SYSDATE );

Line 21404: FROM OE_FND_COMMON_LOOKUPS_V

21400: END IF;
21401:
21402: SELECT 'VALID'
21403: INTO l_dummy
21404: FROM OE_FND_COMMON_LOOKUPS_V
21405: WHERE LOOKUP_CODE = p_Include_On_Returns_Flag
21406: AND LOOKUP_TYPE = l_lookup_type
21407: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
21408: AND NVL(END_DATE_ACTIVE, SYSDATE );