DBA Data[Home] [Help]

APPS.OPI_DBI_JOBS_PKG dependencies on WIP_FLOW_SCHEDULES

Line 859: FROM wip_flow_schedules fl

855: fl.status lookup_code,
856: fl.organization_id organization_id,
857: fl.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE,
858: 1 line_type
859: FROM wip_flow_schedules fl
860: WHERE /*fl.status = 2
861: AND */fl.scheduled_start_date >= g_global_start_date
862: ) jobsinner,
863: wip_entities en,

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