APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WORKORDERS

Line 198: FROM AHL_WORKORDERS

194: IF (p_workorder_id IS NOT NULL AND
195: p_workorder_id <> FND_API.G_MISS_NUM) THEN
196:
197: SELECT visit_task_id INTO x_visit_task_id
198: FROM AHL_WORKORDERS
199: WHERE workorder_id = p_workorder_id;
200: END IF;
201: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
202: IF G_DEBUG='Y' THEN

Line 231: FROM AHL_WORKORDERS

227: --
228: IF p_workorder_id IS NOT NULL THEN
229: --
230: SELECT workorder_id INTO x_workorder_id
231: FROM AHL_WORKORDERS
232: WHERE workorder_id = p_workorder_id;
233: ELSE
234: --
235: SELECT workorder_id INTO x_workorder_id

Line 236: FROM AHL_WORKORDERS

232: WHERE workorder_id = p_workorder_id;
233: ELSE
234: --
235: SELECT workorder_id INTO x_workorder_id
236: FROM AHL_WORKORDERS
237: WHERE workorder_name = p_job_number;
238: END IF;
239:
240: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 698: FROM ahl_workorders

694: CURSOR Get_job_number(c_workorder_id IN NUMBER)
695: IS
696: SELECT workorder_name job_number,
697: wip_entity_id
698: FROM ahl_workorders
699: WHERE workorder_id = c_workorder_id;
700: -- Fix for bug# 6594189. Allow for statuses all statuses other than closed,
701: -- cancelled, parts hold etc.
702: --Check for status

Line 705: SELECT 1 FROM ahl_workorders

701: -- cancelled, parts hold etc.
702: --Check for status
703: CURSOR Check_wo_status_cur(c_workorder_id IN NUMBER)
704: IS
705: SELECT 1 FROM ahl_workorders
706: WHERE workorder_id = c_workorder_id
707: /*
708: AND (status_code = 3 or
709: status_code = 1);

Line 2102: FROM ahl_workorders

2098: --Check for status Released or Unreleased
2099: CURSOR Check_wo_status_cur(c_workorder_id IN NUMBER)
2100: IS
2101: SELECT 1
2102: FROM ahl_workorders
2103: WHERE workorder_id = c_workorder_id
2104: AND (status_code = 3 or
2105: status_code = 1);
2106: --Get wo transaction id

Line 2120: FROM ahl_workorders

2116: -- Get job number details
2117: CURSOR Get_job_number(c_workorder_id IN NUMBER)
2118: IS
2119: SELECT workorder_name
2120: FROM ahl_workorders
2121: WHERE workorder_id = c_workorder_id;
2122: -- rroy
2123: -- ACL Changes
2124:

Line 2909: FROM ahl_workorders

2905: --Get job number
2906: CURSOR Get_job_details(c_workorder_id IN NUMBER)
2907: IS
2908: SELECT workorder_name
2909: FROM ahl_workorders
2910: WHERE workorder_id = c_workorder_id;
2911: -- Bug # 6680137 - begin.
2912: CURSOR c_get_wo_status(c_workorder_id IN NUMBER)
2913: IS

Line 2917: AHL_WORKORDERS AWO

2913: IS
2914: SELECT
2915: AWO.status_code
2916: FROM
2917: AHL_WORKORDERS AWO
2918: WHERE
2919: workorder_id = c_workorder_id;
2920: -- Bug # 6680137 - end
2921: -- Get schedule material details

Line 2969: AHL_WORKORDERS AWOS,

2965: AVST.department_id,
2966: AWOS.workorder_name,
2967: AWOS.wip_entity_id
2968: FROM
2969: AHL_WORKORDERS AWOS,
2970: AHL_SCHEDULE_MATERIALS ASML,
2971: wip_requirement_operations wipr,
2972: MTL_SYSTEM_ITEMS_VL MSIV,
2973: AHL_VISITS_VL AVST,

Line 4093: FROM ahl_workorders A,

4089: IS
4090: SELECT a.visit_id,
4091: visit_task_id,
4092: organization_id
4093: FROM ahl_workorders A,
4094: ahl_visits_b b
4095: WHERE workorder_id = c_workorder_id
4096: AND a.visit_id = b.visit_id;
4097: