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 1154: -- Check Asset Item type value based on mfg_lookups

1150: FROM MTL_PARAMETERS
1151: WHERE ORGANIZATION_ID = cr.organization_id
1152: AND (NVL(EAM_ENABLED_FLAG, 'N') = 'Y' or cr.organization_id = master_organization_id);
1153: --Bug:2672219 and NVL(EAM_ENABLED_FLAG, 'N') = 'Y';
1154: -- Check Asset Item type value based on mfg_lookups
1155: l_col_name := 'EAM_ITEM_TYPE';
1156: l_msg_name := 'INV_INVALID_ATTR_COL_VALUE';
1157: --l_msg_token := l_col_name;
1158:

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

1325: status := 1;
1326: END IF;
1327:
1328: -- For EAM Asset Activity item, validate Activity Type, Activity Cause,
1329: -- and Shutdown Type attribute values based on mfg_lookups.
1330: -- Convert lookup code to char since columns are varchar2, and
1331: -- mfg_lookups code is number.
1332:
1333: IF ( cr.EAM_ITEM_TYPE = 2 ) THEN

Line 1331: -- mfg_lookups code is number.

1327:
1328: -- For EAM Asset Activity item, validate Activity Type, Activity Cause,
1329: -- and Shutdown Type attribute values based on mfg_lookups.
1330: -- Convert lookup code to char since columns are varchar2, and
1331: -- mfg_lookups code is number.
1332:
1333: IF ( cr.EAM_ITEM_TYPE = 2 ) THEN
1334: stmt := 831;
1335: IF ( cr.EAM_ACTIVITY_TYPE_CODE IS NOT NULL ) THEN