APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_WORKORDERS

Line 175: ahl_workorders wo,

171: wo.workorder_id,
172: wo.status_code
173: FROM
174: ahl_visit_tasks_b vtsk,
175: ahl_workorders wo,
176: ahl_unit_effectivities_b ue
177: WHERE
178: ue.cs_incident_id = p_incident_id
179: AND ue.unit_effectivity_id = vtsk.unit_effectivity_id

Line 1321: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)

1317: SELECT 'X'
1318: FROM mtl_system_items_b mtl, csi_item_instances csi
1319: WHERE csi.instance_id = c_instance_id
1320: AND csi.inventory_item_id = mtl.inventory_item_id
1321: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)
1322: AND mtl.serial_number_control_code = 1;
1323:
1324: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1325: SELECT csi.quantity

Line 1327: ahl_workorders wo

1323:
1324: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1325: SELECT csi.quantity
1326: FROM CSI_ITEM_INSTANCES csi,
1327: ahl_workorders wo
1328: WHERE csi.instance_id = c_instance_id
1329: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1330: AND wo.workorder_id = c_wo_id
1331: AND csi.location_type_code = 'WIP'

Line 1908: AHL_WORKORDERS B

1904: CURSOR default_item_org_id(p_workorder_id IN NUMBER) IS
1905: SELECT A.inventory_item_id,
1906: A.item_organization_id
1907: FROM AHL_VISIT_TASKS_B A,
1908: AHL_WORKORDERS B
1909: WHERE A.visit_task_id = B.visit_task_id
1910: AND B.workorder_id = p_workorder_id;
1911:
1912: CURSOR default_incident_type_id is

Line 2110: AHL_WORKORDERS WO

2106: cursor c_visit_task_csr(c_Nonroutine_wo_id IN NUMBER) IS
2107: SELECT
2108: WO.visit_task_id
2109: FROM
2110: AHL_WORKORDERS WO
2111: WHERE
2112: WO.workorder_id = c_Nonroutine_wo_id;
2113:
2114: -- Added by jaramana on Oct 15

Line 2120: ahl_workorders awo,

2116: IS
2117: SELECT
2118: awo.workorder_id
2119: FROM
2120: ahl_workorders awo,
2121: ahl_visit_tasks_b vtsk
2122: WHERE
2123: awo.visit_task_id = vtsk.visit_task_id
2124: AND awo.master_workorder_flag = 'Y'

Line 2147: FROM ahl_workorders

2143: --5. cursor for retrieving the non master workorder id which is passed as to_workorder_id when calling move_intance_location
2144: CURSOR get_nonmaster_wo_id(p_nr_wo_id IN NUMBER)
2145: IS
2146: SELECT workorder_id
2147: FROM ahl_workorders
2148: WHERE MASTER_WORKORDER_FLAG = 'N'
2149: AND wip_entity_id in
2150: (SELECT rel.child_object_id
2151: FROM wip_sched_relationships rel START

Line 2152: WITH REL.parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_nr_wo_id)

2148: WHERE MASTER_WORKORDER_FLAG = 'N'
2149: AND wip_entity_id in
2150: (SELECT rel.child_object_id
2151: FROM wip_sched_relationships rel START
2152: WITH REL.parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_nr_wo_id)
2153: CONNECT BY REL.parent_object_id = PRIOR REL.child_object_id
2154: AND REL.parent_object_type_id = PRIOR REL.child_object_type_id
2155: AND REL.relationship_type = 1
2156: )

Line 2520: from ahl_workorders

2516: WHERE incident_type_id = c_req_type_id;
2517: CURSOR GetOrgTaskDet(c_org_wo_id NUMBER)
2518: Is
2519: Select visit_task_id
2520: from ahl_workorders
2521: where workorder_id = c_org_wo_id;
2522:
2523: CURSOR getUnitEffectivity(p_incident_id NUMBER)
2524: IS

Line 2867: from ahl_workorders

2863: IS
2864: CURSOR GetWoName
2865: Is
2866: Select workorder_name
2867: from ahl_workorders
2868: where workorder_id = p_wo_id;
2869: Cursor GetInstanceNumber
2870: Is
2871: Select instance_number

Line 2905: from ahl_workorders

2901:
2902: CURSOR GetWoName
2903: Is
2904: Select workorder_name
2905: from ahl_workorders
2906: where workorder_id = p_sr_task_rec.originating_wo_id;
2907:
2908: CURSOR GetInstanceDet
2909: Is