APPS.INVPVDR4 dependencies on MFG_LOOKUPS

Line 50: FROM MFG_LOOKUPS

46: -- Added the cursor for bug # 3762750
47: CURSOR c_mfglookup_exists(cp_lookup_type VARCHAR2,
48: cp_lookup_code VARCHAR2) IS
49: SELECT 'x'
50: FROM MFG_LOOKUPS
51: WHERE LOOKUP_TYPE = cp_lookup_type
52: AND LOOKUP_CODE = cp_lookup_code
53: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
54: AND ENABLED_FLAG = 'Y';

Line 1160: -- Check Asset Item type value based on mfg_lookups

1156: FROM MTL_PARAMETERS
1157: WHERE ORGANIZATION_ID = cr.organization_id
1158: AND (NVL(EAM_ENABLED_FLAG, 'N') = 'Y' or cr.organization_id = master_organization_id);*/
1159: --Bug:2672219 and NVL(EAM_ENABLED_FLAG, 'N') = 'Y';
1160: -- Check Asset Item type value based on mfg_lookups
1161: l_col_name := 'EAM_ITEM_TYPE';
1162: l_msg_name := 'INV_INVALID_ATTR_COL_VALUE';
1163: --l_msg_token := l_col_name;
1164:

Line 1336: -- and Shutdown Type attribute values based on mfg_lookups.

1332: status := 1;
1333: END IF;
1334: */
1335: -- For EAM Asset Activity item, validate Activity Type, Activity Cause,
1336: -- and Shutdown Type attribute values based on mfg_lookups.
1337: -- Convert lookup code to char since columns are varchar2, and
1338: -- mfg_lookups code is number.
1339:
1340: IF ( cr.EAM_ITEM_TYPE = 2 ) THEN

Line 1338: -- mfg_lookups code is number.

1334: */
1335: -- For EAM Asset Activity item, validate Activity Type, Activity Cause,
1336: -- and Shutdown Type attribute values based on mfg_lookups.
1337: -- Convert lookup code to char since columns are varchar2, and
1338: -- mfg_lookups code is number.
1339:
1340: IF ( cr.EAM_ITEM_TYPE = 2 ) THEN
1341: stmt := 831;
1342: IF ( cr.EAM_ACTIVITY_TYPE_CODE IS NOT NULL ) THEN