DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PVT dependencies on FND_LOOKUPS

Line 1772: FND_LOOKUPS

1768: 1
1769: INTO
1770: l_chk
1771: FROM
1772: FND_LOOKUPS
1773: WHERE lookup_type = 'MVT_DELIVERY_TERMS'
1774: AND lookup_code = l_orig_mvmt_transaction.delivery_terms;
1775:
1776: EXCEPTION

Line 2042: FROM fnd_lookups

2038: END IF;
2039:
2040: SELECT COUNT(*)
2041: INTO l_count
2042: FROM fnd_lookups
2043: WHERE lookup_type = p_lookup_type
2044: AND lookup_code = p_rule_field_value;
2045:
2046: IF l_count=0

Line 2113: FROM fnd_lookups

2109:
2110: ----check if the value from the form matches the lookup value
2111: SELECT COUNT(*)
2112: INTO l_count1
2113: FROM fnd_lookups
2114: WHERE lookup_type = p_lookup_type
2115: AND lookup_code = l_form_vat_value;
2116:
2117: ----- the value does not match, this is the error

Line 2394: from fnd_lookups

2390: ELSE
2391:
2392: BEGIN
2393: Select MEANING into lookup_value
2394: from fnd_lookups
2395: where lookup_type = rules_rec.attribute_lookup_type
2396: and lookup_code = rule_field_value;
2397: EXCEPTION
2398: WHEN NO_DATA_FOUND THEN