APPS.OPI_DBI_JOBS_PKG dependencies on MFG_LOOKUPS

Line 865: mfg_lookups ml1

861: AND */fl.scheduled_start_date >= g_global_start_date
862: ) jobsinner,
863: wip_entities en,
864: CST_ITEM_COSTS itemcost,
865: mfg_lookups ml1
866: WHERE ((en.entity_type in (1,2,3,5,8)
867: AND ml1.lookup_type in ('WIP_JOB_STATUS')) OR
868: (en.entity_type in (4)
869: AND ml1.lookup_type in ('WIP_FLOW_SCHEDULE_STATUS')))

Line 1167: FROM WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI, MFG_LOOKUPS ML1

1163: DI.LAST_UPDATE_DATE,
1164: EN.WIP_ENTITY_NAME JOB_NAME,
1165: 1 line_type,
1166: DI.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
1167: FROM WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI, MFG_LOOKUPS ML1
1168: WHERE
1169: DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
1170: DI.JOB_TYPE = 1 AND -- Only Standard Jobs
1171: EN.ENTITY_TYPE IN (1,3,5,8) AND -- Discrete jobs and Closed discrete jobs

Line 1192: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, MFG_LOOKUPS ML1

1188: to_char(RE.REPETITIVE_SCHEDULE_ID) JOB_NAME,
1189: 1 line_type,
1190: RE.last_unit_completion_date SCHEDULED_COMPLETION_DATE
1191: FROM
1192: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, MFG_LOOKUPS ML1
1193: WHERE
1194: RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
1195: EN.ENTITY_TYPE = 2 AND -- Repetitive Schedules
1196: ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE = RE.STATUS_TYPE AND

Line 1216: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL, MFG_LOOKUPS ML1

1212: to_char(EN.WIP_ENTITY_ID) JOB_NAME,
1213: 1 line_type,
1214: FL.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
1215: FROM
1216: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL, MFG_LOOKUPS ML1
1217: WHERE
1218: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
1219: EN.ENTITY_TYPE = 4 AND -- Flow Schedules
1220: ML1.LOOKUP_TYPE = 'WIP_FLOW_SCHEDULE_STATUS' AND ML1.LOOKUP_CODE = FL.STATUS AND