APPS.AHL_PRD_PRINT_PVT dependencies on AHL_OPERATIONS_B

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 2332: AHL_OPERATIONS_B OP

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(+)
2335: AND RP.route_id = c_route_id
2336: AND WO.workorder_id = c_wo_id

Line 2834: FROM AHL_OPERATIONS_B OP

2830: OP.ATTRIBUTE12 "Attribute12" ,
2831: OP.ATTRIBUTE13 "Attribute13" ,
2832: OP.ATTRIBUTE14 "Attribute14" ,
2833: OP.ATTRIBUTE15 "Attribute15"
2834: FROM AHL_OPERATIONS_B OP
2835: WHERE OP.OPERATION_ID = :1';
2836:
2837: l_qa_plan_attr VARCHAR2(1000) := '
2838: SELECT char_id "CharId" ,

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 8084: AHL_OPERATIONS_B OP

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(+)
8087: AND RP.route_id = c_route_id
8088: AND WO.workorder_id = c_wo_id

Line 8303: FROM AHL_OPERATIONS_B OP

8299: OP.ATTRIBUTE12 "Attribute12" ,
8300: OP.ATTRIBUTE13 "Attribute13" ,
8301: OP.ATTRIBUTE14 "Attribute14" ,
8302: OP.ATTRIBUTE15 "Attribute15"
8303: FROM AHL_OPERATIONS_B OP
8304: WHERE OP.OPERATION_ID = :1';
8305:
8306: l_qa_plan_attr VARCHAR2(1000) := '
8307: SELECT char_id "CharId" ,