eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PRINT_PVT dependencies on AHL_WORKORDERS

Line 208: AHL_WORKORDERS WO,

204: DOC.PAGE,
205: DOC.FIGURE,
206: DOC.NOTE
207: FROM
208: AHL_WORKORDERS WO,
209: AHL_DOCUMENT_ASSOS_V DOC
210: WHERE
211: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
212: AND DOC.ASO_OBJECT_TYPE_CODE = ''ROUTE''

Line 252: AHL_WORKORDERS WO,

248: DOC.PAGE,
249: DOC.FIGURE,
250: DOC.NOTE
251: FROM
252: AHL_WORKORDERS WO,
253: AHL_VISIT_TASKS_B VST,
254: AHL_DOCUMENT_ASSOS_V DOC
255: WHERE
256: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID

Line 277: AHL_WORKORDERS WO,

273: DOC.PAGE,
274: DOC.FIGURE,
275: DOC.NOTE
276: FROM
277: AHL_WORKORDERS WO,
278: CSI_II_RELATIONSHIPS CSI,
279: AHL_VISIT_TASKS_B VTS,
280: AHL_DOCUMENT_ASSOS_V DOC
281: WHERE

Line 305: AHL_WORKORDERS WO,

301: DOC.PAGE,
302: DOC.FIGURE,
303: DOC.NOTE
304: FROM
305: AHL_WORKORDERS WO,
306: AHL_PC_ASSOCIATIONS PCA,
307: AHL_VISIT_TASKS_B VTS,
308: AHL_DOCUMENT_ASSOS_V DOC
309: WHERE

Line 354: AHL_WORKORDERS

350: SELECT
351: PLAN_ID,
352: COLLECTION_ID
353: FROM
354: AHL_WORKORDERS
355: WHERE
356: workorder_id = p_workorder_id;
357:
358: --Cursor for getting workorder operation plan_id and collection id

Line 1290: ahl_workorders wo,

1286:
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

Line 2010: FROM AHL_WORKORDERS WO ,

2006: DECODE(WIP.DATE_RELEASED, NULL, NULL,
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

Line 2055: (select job_number from ahl_workorders_v WO , AHL_UNIT_EFFECTIVITIES_B UE where

2051: UE.ata_code,
2052: WO.incident_number,
2053: HZ.party_name,
2054: --UE.originating_wo_id
2055: (select job_number from ahl_workorders_v WO , AHL_UNIT_EFFECTIVITIES_B UE where
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

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 2110: FROM AHL_WORKORDERS WO --,

2106: WHERE HZ.PARTY_ID = CSI.OWNER_PARTY_ID
2107: )
2108: PARTY_NAME,
2109: (SELECT WORKORDER_NAME
2110: FROM AHL_WORKORDERS WO --,
2111: --AHL_UNIT_EFFECTIVITIES_B UE1
2112: WHERE WO.WORKORDER_ID = UE.ORIGINATING_WO_ID
2113: --AND WO.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
2114: )

Line 2127: AHL_WORKORDERS W ,

2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,
2125: --CS_INCIDENTS_ALL_B CSIN ,
2126: --AHL_VISIT_TASKS_VL VTS ,
2127: AHL_WORKORDERS W ,
2128: (SELECT LOOKUP_CODE ,
2129: MEANING
2130: FROM FND_LOOKUP_VALUES
2131: WHERE LOOKUP_TYPE = 'AHL_ENIGMA_MODEL_CODE'

Line 2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI

2160: (SELECT f.meaning from fnd_lookup_values_vl f
2161: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
2162: FROM --AHL_JOB_OPER_MATERIALS_V JM,
2163: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI
2165: WHERE WO.wip_entity_id = WRO.wip_entity_id
2166: AND WO.visit_task_id = ASM.visit_task_id
2167: AND ASM.operation_sequence = WRO.operation_seq_num
2168: AND ASM.inventory_item_id = WRO.inventory_item_id

Line 2191: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO

2187: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
2188: where AWO.workorder_id = wo.workorder_id
2189: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
2190: FROM WIP_OPERATION_RESOURCES WOR,
2191: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
2192: WHERE WO.workorder_id = c_wo_id
2193: AND WOR.resource_id = BOM.resource_id
2194: AND WO.wip_entity_id = WOR.wip_entity_id
2195: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'

Line 2202: --from ahl_workorders_v

2198:
2199: CURSOR get_wo_id(c_visit_id IN NUMBER)
2200: IS
2201: SELECT workorder_id
2202: --from ahl_workorders_v
2203: FROM ahl_workorders
2204: WHERE visit_id = c_visit_id
2205: AND master_workorder_flag = 'N'
2206: AND STATUS_CODE NOT IN ( '7','12','14','15','17','22' )

Line 2203: FROM ahl_workorders

2199: CURSOR get_wo_id(c_visit_id IN NUMBER)
2200: IS
2201: SELECT workorder_id
2202: --from ahl_workorders_v
2203: FROM ahl_workorders
2204: WHERE visit_id = c_visit_id
2205: AND master_workorder_flag = 'N'
2206: AND STATUS_CODE NOT IN ( '7','12','14','15','17','22' )
2207: order by workorder_name;

Line 2212: --FROM AHL_WORKORDERS_V

2208:
2209: CURSOR get_ue_wo_id(c_ue_id IN NUMBER)
2210: IS
2211: SELECT wo.WORKORDER_ID
2212: --FROM AHL_WORKORDERS_V
2213: FROM AHL_WORKORDERS WO,
2214: ahl_visit_tasks_b tsk
2215: WHERE wo.visit_task_id = tsk.visit_task_id
2216: AND wo.master_workorder_flag = 'N'

Line 2213: FROM AHL_WORKORDERS WO,

2209: CURSOR get_ue_wo_id(c_ue_id IN NUMBER)
2210: IS
2211: SELECT wo.WORKORDER_ID
2212: --FROM AHL_WORKORDERS_V
2213: FROM AHL_WORKORDERS WO,
2214: ahl_visit_tasks_b tsk
2215: WHERE wo.visit_task_id = tsk.visit_task_id
2216: AND wo.master_workorder_flag = 'N'
2217: AND WO.STATUS_CODE NOT IN ('7','12','14','15','17','22')

Line 2422: FROM AHL_WORKORDERS

2418: CURSOR get_wo_qa_res_csr(c_wo_id IN NUMBER)
2419: IS
2420: SELECT plan_id,
2421: collection_id
2422: FROM AHL_WORKORDERS
2423: WHERE workorder_id = c_wo_id;
2424:
2425: CURSOR qa_result_csr(c_collection_id IN NUMBER)
2426: IS

Line 2440: FROM ahl_workorders

2436:
2437: CURSOR get_wo_no(c_wo_id IN NUMBER)
2438: IS
2439: SELECT workorder_name
2440: FROM ahl_workorders
2441: WHERE workorder_id = c_wo_id;
2442:
2443: CURSOR qa_plan_attr_csr (c_plan_id IN NUMBER)
2444: IS

Line 2584: ahl_workorders wo

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
2588: ) RELEASE_DATE

Line 2594: AHL_WORKORDERS WO,

2590: AHL_UNIT_EFFECTIVITIES_B UE,
2591: MTL_SYSTEM_ITEMS_KFV MTL ,
2592: CSI_ITEM_INSTANCES CSI ,
2593: CS_INCIDENTS_ALL_B CS,
2594: AHL_WORKORDERS WO,
2595: AHL_VISIT_TASKS_B VISIT_TASK,
2596: HZ_PARTIES PARTY ,
2597: CS_INCIDENT_TYPES_TL CS_TYPE,
2598: (SELECT INCIDENT_ID ,

Line 2715: FROM --AHL_WORKORDERS WO ,

2711: DOC.SUBJECT "Subject" ,
2712: DOC.PAGE "Page" ,
2713: DOC.FIGURE "Figure" ,
2714: DOC.NOTE "Note"
2715: FROM --AHL_WORKORDERS WO ,
2716: AHL_DOCUMENT_ASSOS_V DOC,
2717: AHL_DOCUMENTS_V DOCV
2718: WHERE --WO.ROUTE_ID = DOC.ASO_OBJECT_ID
2719: DOC.DOCUMENT_ID = DOCV.DOCUMENT_ID

Line 2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo

2860: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2861: AND NVL(ccr.disabled_flag,''N'') = ''N''
2862: )
2863: "CurrentReading"
2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
2865: FROM csi_counter_associations cca,
2866: csi_counters_vl cc ,
2867: ahl_workorders WO ,
2868: ahl_visit_tasks_b tsk

Line 2867: ahl_workorders WO ,

2863: "CurrentReading"
2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
2865: FROM csi_counter_associations cca,
2866: csi_counters_vl cc ,
2867: ahl_workorders WO ,
2868: ahl_visit_tasks_b tsk
2869: WHERE cca.counter_id = cc.counter_id
2870: AND wo.visit_task_id = tsk.visit_task_id
2871: AND source_object_code = ''CP''

Line 2928: AHL_WORKORDERS WO

2924: PP.QUANTITY "Quantity" ,
2925: PP.DURATION "Duration" ,
2926: PP.UOM_NAME "UOM"
2927: FROM AHL_PP_REQUIREMENT_V PP,
2928: AHL_WORKORDERS WO
2929: WHERE PP.JOB_ID = WO.WORKORDER_ID
2930: AND PP.resource_type_code = 1
2931: AND WO.WORKORDER_ID = :1';
2932:

Line 2948: FROM AHL_WORKORDERS WO,

2944: (SELECT --TO_CHAR(WDJ.DATE_RELEASED, ''YYYY-MM-DD hh24:mi:ss'')
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

Line 3089: FROM ahl_workorders

3085:
3086: BEGIN
3087: SELECT visit_id
3088: INTO l_visit_id
3089: FROM ahl_workorders
3090: WHERE workorder_id = l_wo_id_tbl(1);
3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3101: FROM ahl_visit_tasks_b vst, ahl_unit_effectivities_b ue, ahl_workorders wo

3097: l_visit_id := p_object_id;
3098: BEGIN
3099: SELECT vst.unit_effectivity_id
3100: BULK COLLECT INTO l_ue_id_tbl
3101: FROM ahl_visit_tasks_b vst, ahl_unit_effectivities_b ue, ahl_workorders wo
3102: WHERE vst.visit_id = l_visit_id
3103: and vst.task_type_code = 'SUMMARY'
3104: and wo.visit_task_id = vst.visit_task_id
3105: and wo.status_code NOT IN ('7','12','14','15','17','22')

Line 3201: FROM ahl_workorders WO,

3197: BEGIN
3198:
3199: SELECT VST.unit_effectivity_id
3200: INTO l_ue_id_tbl(1)
3201: FROM ahl_workorders WO,
3202: ahl_visit_tasks_b VST
3203: WHERE WO.visit_task_id = VST.visit_task_id
3204: AND WO.workorder_id = l_wo_id_tbl(1);
3205:

Line 3665: FROM ahl_workorders

3661: IF (p_object_type = 'VST')THEN
3662: BEGIN
3663: SELECT workorder_id
3664: INTO l_wo_id
3665: FROM ahl_workorders
3666: WHERE visit_task_id IS NULL
3667: AND visit_id = p_object_id;
3668:
3669: SELECT UC.UNIT_CONFIG_HEADER_ID, UC.NAME, VST.item_instance_id

Line 3685: FROM ahl_workorders WO,

3681: l_wo_id := p_object_id;
3682: l_uc_id := AHL_PRD_PARTS_CHANGE_PVT.Get_UnitConfig_ID(l_wo_id);
3683: SELECT VT.instance_id
3684: INTO l_count_instance_id
3685: FROM ahl_workorders WO,
3686: ahl_visit_tasks_b VT
3687: WHERE WO.visit_task_id = VT.visit_task_id
3688: AND WO.workorder_id = l_wo_id;
3689:

Line 3693: FROM ahl_workorders WO,

3689:
3690: ELSIF (p_object_type = 'MR' OR p_object_type = 'NR')THEN
3691: SELECT WO.workorder_id, VT.INSTANCE_ID
3692: INTO l_wo_id, l_count_instance_id
3693: FROM ahl_workorders WO,
3694: ahl_visit_tasks_b vt
3695: WHERE wo.visit_task_id = vt.visit_task_id
3696: AND vt.task_type_code = 'SUMMARY'
3697: AND vt.UNIT_EFFECTIVITY_ID = p_object_id ;

Line 3794: FROM ahl_workorders wo,

3790: IF (p_object_type = 'VST') THEN
3791: BEGIN
3792: SELECT wo.workorder_id
3793: BULK COLLECT INTO l_wo_id_tbl
3794: FROM ahl_workorders wo,
3795: ahl_visit_tasks_b vt
3796: WHERE wo.visit_task_id = vt.visit_task_id
3797: AND vt.task_type_code = 'UNASSOCIATED'
3798: AND wo.status_code NOT IN ('7','12','14','15','17','22')

Line 3813: FROM ahl_workorders wo,

3809: IF (p_object_type = 'WO') THEN
3810: BEGIN
3811: SELECT vt.task_type_code
3812: INTO l_task_type
3813: FROM ahl_workorders wo,
3814: ahl_visit_tasks_b vt
3815: WHERE wo.visit_task_id = vt.visit_task_id
3816: AND wo.workorder_id = l_wo_id_tbl(1);
3817: END;

Line 7878: FROM AHL_WORKORDERS WO --,

7874: WHERE HZ.PARTY_ID = CSI.OWNER_PARTY_ID
7875: )
7876: PARTY_NAME,
7877: (SELECT WORKORDER_NAME
7878: FROM AHL_WORKORDERS WO --,
7879: --AHL_UNIT_EFFECTIVITIES_B UE1
7880: WHERE WO.WORKORDER_ID = UE.ORIGINATING_WO_ID
7881: --AND WO.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
7882: )

Line 7895: AHL_WORKORDERS W ,

7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,
7893: --CS_INCIDENTS_ALL_B CSIN ,
7894: --AHL_VISIT_TASKS_VL VTS ,
7895: AHL_WORKORDERS W ,
7896: (SELECT LOOKUP_CODE ,
7897: MEANING
7898: FROM FND_LOOKUP_VALUES
7899: WHERE LOOKUP_TYPE = 'AHL_ENIGMA_MODEL_CODE'

Line 7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP

7944: (SELECT f.meaning from fnd_lookup_values_vl f
7945: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
7946: FROM --AHL_JOB_OPER_MATERIALS_V JM,
7947: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP
7949: WHERE WO.wip_entity_id = WRO.wip_entity_id
7950: AND WO.visit_task_id = ASM.visit_task_id
7951: AND ASM.operation_sequence = WRO.operation_seq_num
7952: AND ASM.inventory_item_id = WRO.inventory_item_id

Line 7978: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO

7974: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
7975: where AWO.workorder_id = wo.workorder_id
7976: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
7977: FROM WIP_OPERATION_RESOURCES WOR,
7978: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
7979: WHERE WO.workorder_id = c_wo_id
7980: AND WOR.resource_id = BOM.resource_id
7981: AND WO.wip_entity_id = WOR.wip_entity_id
7982: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'

Line 8109: FROM AHL_WORKORDERS

8105: CURSOR get_wo_qa_res_csr(c_wo_id IN NUMBER)
8106: IS
8107: SELECT plan_id,
8108: collection_id
8109: FROM AHL_WORKORDERS
8110: WHERE workorder_id = c_wo_id;
8111:
8112: CURSOR qa_result_csr(c_collection_id IN NUMBER)
8113: IS

Line 8127: FROM ahl_workorders

8123:
8124: CURSOR get_wo_no(c_wo_id IN NUMBER)
8125: IS
8126: SELECT workorder_name
8127: FROM ahl_workorders
8128: WHERE workorder_id = c_wo_id;
8129:
8130: CURSOR qa_plan_attr_csr (c_plan_id IN NUMBER)
8131: IS

Line 8207: FROM --AHL_WORKORDERS WO ,

8203: DOC.SUBJECT "Subject" ,
8204: DOC.PAGE "Page" ,
8205: DOC.FIGURE "Figure" ,
8206: DOC.NOTE "Note"
8207: FROM --AHL_WORKORDERS WO ,
8208: AHL_DOCUMENT_ASSOS_V DOC,
8209: AHL_DOCUMENTS_V DOCV
8210: WHERE --WO.ROUTE_ID = DOC.ASO_OBJECT_ID
8211: DOC.DOCUMENT_ID = DOCV.DOCUMENT_ID

Line 8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo

8328: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
8329: AND NVL(ccr.disabled_flag,''N'') = ''N''
8330: )
8331: "CurrentReading"
8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
8333: FROM csi_counter_associations cca,
8334: csi_counters_vl cc ,
8335: ahl_workorders WO ,
8336: ahl_visit_tasks_b tsk

Line 8335: ahl_workorders WO ,

8331: "CurrentReading"
8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
8333: FROM csi_counter_associations cca,
8334: csi_counters_vl cc ,
8335: ahl_workorders WO ,
8336: ahl_visit_tasks_b tsk
8337: WHERE cca.counter_id = cc.counter_id
8338: AND wo.visit_task_id = tsk.visit_task_id
8339: AND source_object_code = ''CP''

Line 8396: AHL_WORKORDERS WO

8392: PP.QUANTITY "Quantity" ,
8393: PP.DURATION "Duration" ,
8394: PP.UOM_NAME "UOM"
8395: FROM AHL_PP_REQUIREMENT_V PP,
8396: AHL_WORKORDERS WO
8397: WHERE PP.JOB_ID = WO.WORKORDER_ID
8398: AND PP.resource_type_code = 1
8399: AND WO.WORKORDER_ID = :1';
8400: