APPS.AHL_PRD_PRINT_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

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 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 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(+)