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_WORKORDER_OPERATIONS

Line 171: ahl_workorder_operations_v

167: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,
168: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,
169: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE
170: FROM
171: ahl_workorder_operations_v
172: WHERE
173: workorder_operation_id = ';
174:
175:

Line 230: AHL_WORKORDER_OPERATIONS WOP,

226: DOC.PAGE,
227: DOC.FIGURE,
228: DOC.NOTE
229: FROM
230: AHL_WORKORDER_OPERATIONS WOP,
231: AHL_DOCUMENT_ASSOS_V DOC
232: WHERE
233: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
234: AND DOC.ASO_OBJECT_TYPE_CODE = ''OPERATION''

Line 324: ahl_Workorder_Operations wop,

320: pf.full_name employee_name
321: FROM
322: ahl_Work_Assignments wass,
323: ahl_Operation_Resources opr,
324: ahl_Workorder_Operations wop,
325: per_people_f pf,
326: per_Person_Types Pt
327: WHERE
328: wass.Operation_Resource_Id = opr.operation_resource_id and

Line 344: ahl_workorder_operations

340: SELECT
341: workorder_operation_id,
342: operation_sequence_num
343: FROM
344: ahl_workorder_operations
345: WHERE
346: workorder_id = p_workorder_id;
347:
348: --Cursor for getting workorder plan_id and collection id

Line 365: AHL_WORKORDER_OPERATIONS

361: OPERATION_SEQUENCE_NUM, --balaji added for Bug 6777371
362: PLAN_ID,
363: COLLECTION_ID
364: FROM
365: AHL_WORKORDER_OPERATIONS
366: WHERE
367: workorder_id = p_wo_id;
368:
369: --declare all local variables here.

Line 608: AHL_WORKORDER_OPERATIONS WOP

604: ,wop.operation_sequence_num
605: ,''LINE'')),
606: ''YYYY-MM-DD hh:mm:ss+HH:MM'') Assigned_End_Date
607: FROM
608: AHL_WORKORDER_OPERATIONS WOP
609: GROUP BY workorder_id
610: ) WODE ';
611:
612: l_wo_con_query := l_wo_con_query || l_wo_details_where;

Line 2187: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO

2183: DECODE(nvl(WOR.ASSIGNED_UNITS,0), 0, 0, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) duration ,
2184: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A
2185: WHERE A.UOM_CODE=BOM.UNIT_OF_MEASURE) uom_name,
2186: WOR.RESOURCE_ID,
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

Line 2238: FROM AHL_WORKORDER_OPERATIONS_V WO --AHL_OPERATIONS_B OP

2234: ||'T'
2235: ||TO_CHAR(WO.scheduled_end_date, 'hh24:mi:ss') ) scheduled_end_date,
2236: DECODE(WO.plan_id,NULL,'F','T') isQualityEnabled ,
2237: WO.workorder_operation_id
2238: FROM AHL_WORKORDER_OPERATIONS_V WO --AHL_OPERATIONS_B OP
2239: WHERE -- WO.operation_id = OP.operation_id(+) and
2240: WO.workorder_id = c_wo_id
2241: ORDER BY 1 ;
2242:

Line 2330: FROM AHL_WORKORDER_OPERATIONS_V WO,

2326: OP.ENIGMA_DOC_ID ,
2327: OP.OPERATION_ID ,
2328: OP.REVISION_NUMBER ,
2329: OP.LAST_UPDATE_DATE
2330: FROM AHL_WORKORDER_OPERATIONS_V WO,
2331: AHL_ROUTE_OPERATIONS RP ,
2332: AHL_OPERATIONS_B OP
2333: WHERE RP.OPERATION_ID(+) = WO.OPERATION_ID
2334: AND WO.OPERATION_ID = OP.OPERATION_ID(+)

Line 2415: FROM AHL_WORKORDER_OPERATIONS

2411: CURSOR get_op_qa_res_csr(c_wo_op_id IN NUMBER)
2412: IS
2413: SELECT plan_id,
2414: collection_id
2415: FROM AHL_WORKORDER_OPERATIONS
2416: WHERE workorder_operation_id = c_wo_op_id;
2417:
2418: CURSOR get_wo_qa_res_csr(c_wo_id IN NUMBER)
2419: IS

Line 2739: FROM AHL_WORKORDER_OPERATIONS WOP,

2735: DOC.SUBJECT "Subject" ,
2736: DOC.PAGE "Page" ,
2737: DOC.FIGURE "Figure" ,
2738: DOC.NOTE "Note"
2739: FROM AHL_WORKORDER_OPERATIONS WOP,
2740: AHL_DOCUMENT_ASSOS_V DOC ,
2741: AHL_DOCUMENTS_V DOCV
2742: WHERE WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
2743: AND DOC.DOCUMENT_ID = DOCV.DOCUMENT_ID

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 7974: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO

7970: DECODE(nvl(WOR.ASSIGNED_UNITS,0), 0, 0, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) duration ,
7971: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A
7972: WHERE A.UOM_CODE=BOM.UNIT_OF_MEASURE) uom_name,
7973: WOR.RESOURCE_ID,
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

Line 8004: FROM AHL_WORKORDER_OPERATIONS_V WO --AHL_OPERATIONS_B OP

8000: ||'T'
8001: ||TO_CHAR(WO.scheduled_end_date, 'hh24:mi:ss') ) scheduled_end_date,
8002: DECODE(WO.plan_id,NULL,'F','T') isQualityEnabled ,
8003: WO.workorder_operation_id
8004: FROM AHL_WORKORDER_OPERATIONS_V WO --AHL_OPERATIONS_B OP
8005: WHERE -- WO.operation_id = OP.operation_id(+) and
8006: WO.workorder_id = c_wo_id
8007: ORDER BY 1 ;
8008:

Line 8082: FROM AHL_WORKORDER_OPERATIONS_V WO,

8078: OP.OPERATION_ID ,
8079: OP.REVISION_NUMBER ,
8080: OP.LAST_UPDATE_DATE
8081:
8082: FROM AHL_WORKORDER_OPERATIONS_V WO,
8083: AHL_ROUTE_OPERATIONS RP ,
8084: AHL_OPERATIONS_B OP
8085: WHERE RP.OPERATION_ID(+) = WO.OPERATION_ID
8086: AND WO.OPERATION_ID = OP.OPERATION_ID(+)

Line 8102: FROM AHL_WORKORDER_OPERATIONS

8098: CURSOR get_op_qa_res_csr(c_wo_op_id IN NUMBER)
8099: IS
8100: SELECT plan_id,
8101: collection_id
8102: FROM AHL_WORKORDER_OPERATIONS
8103: WHERE workorder_operation_id = c_wo_op_id;
8104:
8105: CURSOR get_wo_qa_res_csr(c_wo_id IN NUMBER)
8106: IS

Line 8231: FROM AHL_WORKORDER_OPERATIONS WOP,

8227: DOC.SUBJECT "Subject" ,
8228: DOC.PAGE "Page" ,
8229: DOC.FIGURE "Figure" ,
8230: DOC.NOTE "Note"
8231: FROM AHL_WORKORDER_OPERATIONS WOP,
8232: AHL_DOCUMENT_ASSOS_V DOC ,
8233: AHL_DOCUMENTS_V DOCV
8234: WHERE WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
8235: AND DOC.DOCUMENT_ID = DOCV.DOCUMENT_ID