APPS.OPI_DBI_JOBS_PKG dependencies on STANDARD

Line 4: -- Standard WHO column information

1: Package Body OPI_DBI_JOBS_PKG AS
2: /*$Header: OPIDJOBSB.pls 120.16 2007/04/04 05:28:57 sdiwakar ship $ */
3:
4: -- Standard WHO column information
5: g_sysdate DATE;
6: g_user_id NUMBER;
7: g_login_id NUMBER;
8: g_program_id NUMBER;

Line 826: WHERE di.job_type = 1 AND -- only standard jobs

822: di.organization_id organization_id,
823: di.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE,
824: 1 line_type
825: FROM wip_discrete_jobs di
826: WHERE di.job_type = 1 AND -- only standard jobs
827: di.status_type in (3,4,5,6,7,12,14,15) AND
828: --di.scheduled_start_date >= g_global_start_date
829: di.date_released >= g_global_start_date
830: UNION ALL

Line 1170: DI.JOB_TYPE = 1 AND -- Only Standard Jobs

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
1172: ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE = DI.STATUS_TYPE AND
1173: --DI.SCHEDULED_START_DATE >= g_global_start_date
1174: DI.date_released >= g_global_start_date