DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PVT dependencies on FND_LOOKUPS

Line 1732: FND_LOOKUPS

1728: 1
1729: INTO
1730: l_chk
1731: FROM
1732: FND_LOOKUPS
1733: WHERE lookup_type = 'MVT_DELIVERY_TERMS'
1734: AND lookup_code = l_orig_mvmt_transaction.delivery_terms;
1735:
1736: EXCEPTION

Line 2002: FROM fnd_lookups

1998: END IF;
1999:
2000: SELECT COUNT(*)
2001: INTO l_count
2002: FROM fnd_lookups
2003: WHERE lookup_type = p_lookup_type
2004: AND lookup_code = p_rule_field_value;
2005:
2006: IF l_count=0

Line 2073: FROM fnd_lookups

2069:
2070: ----check if the value from the form matches the lookup value
2071: SELECT COUNT(*)
2072: INTO l_count1
2073: FROM fnd_lookups
2074: WHERE lookup_type = p_lookup_type
2075: AND lookup_code = l_form_vat_value;
2076:
2077: ----- the value does not match, this is the error

Line 2354: from fnd_lookups

2350: ELSE
2351:
2352: BEGIN
2353: Select MEANING into lookup_value
2354: from fnd_lookups
2355: where lookup_type = rules_rec.attribute_lookup_type
2356: and lookup_code = rule_field_value;
2357: EXCEPTION
2358: WHEN NO_DATA_FOUND THEN