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 21210: FROM OE_FND_COMMON_LOOKUPS_V

21206: END IF;
21207:
21208: SELECT 'VALID'
21209: INTO l_dummy
21210: FROM OE_FND_COMMON_LOOKUPS_V
21211: WHERE LOOKUP_CODE = p_Include_On_Returns_Flag
21212: AND LOOKUP_TYPE = l_lookup_type
21213: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
21214: AND NVL(END_DATE_ACTIVE, SYSDATE );