APPS.AHL_PRD_PRINT_PVT dependencies on WIP_DISCRETE_JOBS

Line 1291: wip_discrete_jobs wipd,

1287: l_query_string := ' select
1288: wo.workorder_id
1289: from
1290: ahl_workorders wo,
1291: wip_discrete_jobs wipd,
1292: ahl_visits_b vst,
1293: ahl_visit_tasks_b vtsk
1294: where
1295: wo.visit_id = vst.visit_id and

Line 2011: WIP_DISCRETE_JOBS WIP ,

2007: TO_CHAR(WIP.DATE_RELEASED,'YYYY-MM-DD')
2008: ||'T'
2009: ||TO_CHAR(WIP.DATE_RELEASED, 'hh24:mi:ss') ) DATE_RELEASED
2010: FROM AHL_WORKORDERS WO ,
2011: WIP_DISCRETE_JOBS WIP ,
2012: AHL_VISITS_B VST ,
2013: HR_ALL_ORGANIZATION_UNITS HROU
2014: WHERE WO.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
2015: AND VST.ORGANIZATION_ID = HROU.ORGANIZATION_ID

Line 2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI

2056: WO.workorder_id = UE.ORIGINATING_WO_ID
2057: and WO.unit_effectivity_id = UE.unit_effectivity_id) OriginatingWorkorder,
2058: WO.item_instance_id,
2059: decode(WO.plan_id,null,'F','T') isQualityEnabled
2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI
2061: WHERE WO.wip_entity_id = WIP.wip_entity_id
2062: AND WO.route_id = RO.route_id (+)
2063: AND UE.unit_effectivity_id(+) = WO.unit_effectivity_id
2064: AND CSI.instance_id = WO.ITEM_INSTANCE_ID(+)

Line 2120: WIP_DISCRETE_JOBS WIP ,

2116: WO.ITEM_INSTANCE_ID ,
2117: DECODE(W.PLAN_ID,NULL,'F','T') ISQUALITYENABLED,
2118: WO.ROUTE_ID
2119: FROM AHL_WORKORDER_TASKS_V WO ,
2120: WIP_DISCRETE_JOBS WIP ,
2121: AHL_ROUTES_B RO ,
2122: AHL_UNIT_EFFECTIVITIES_B UE ,
2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,

Line 2583: from wip_discrete_jobs wip,

2579: ) UE_ATA_REMARKS,
2580: CS.INCIDENT_OCCURRED_DATE,
2581: ATASEQ.UE_ATA_HEADER_REVISION,
2582: (Select wip.date_released
2583: from wip_discrete_jobs wip,
2584: ahl_workorders wo
2585: where wo.wip_entity_id = wip.wip_entity_id
2586: and wo.master_workorder_flag = 'Y'
2587: and wo.visit_task_id = visit_task.visit_task_id

Line 2949: WIP_DISCRETE_JOBS WDJ

2945: DECODE(WDJ.DATE_RELEASED, NULL, NULL, TO_CHAR(WDJ.DATE_RELEASED,''YYYY-MM-DD'')
2946: ||''T''
2947: ||TO_CHAR(WDJ.DATE_RELEASED, ''hh24:mi:ss'') )
2948: FROM AHL_WORKORDERS WO,
2949: WIP_DISCRETE_JOBS WDJ
2950: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
2951: AND WO.VISIT_TASK_ID IS NULL
2952: AND AVB.VISIT_ID = WO.VISIT_ID
2953: ) "ReleaseDate",

Line 7888: WIP_DISCRETE_JOBS WIP ,

7884: WO.ITEM_INSTANCE_ID ,
7885: DECODE(W.PLAN_ID,NULL,'F','T') ISQUALITYENABLED,
7886: WO.ROUTE_ID
7887: FROM AHL_WORKORDER_TASKS_V WO ,
7888: WIP_DISCRETE_JOBS WIP ,
7889: AHL_ROUTES_B RO ,
7890: AHL_UNIT_EFFECTIVITIES_B UE ,
7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,