APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_WORKORDERS

Line 183: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C

179: WHERE UNIT_OF_MEASURE = p_Uom_Desc;
180: -- Cursor for Wip job id.
181: CURSOR WIP_JOB_ID_CUR(p_wo_id NUMBER) IS
182: SELECT A.WIP_ENTITY_ID, C.ORGANIZATION_ID
183: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C
184: WHERE A.WORKORDER_ID = p_wo_id
185: AND B.VISIT_TASK_ID = A.VISIT_TASK_ID
186: AND C.VISIT_ID = B.VISIT_ID;
187: -- Cursor for Work order operation id.

Line 770: l_workorder_name ahl_workorders.workorder_name%TYPE;

766: l_uom_code AHL_SCHEDULE_MATERIALS.UOM%TYPE;
767: l_quantity NUMBER;
768:
769: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
770: l_workorder_name ahl_workorders.workorder_name%TYPE;
771:
772: l_reservation_flag VARCHAR2(1);
773: l_sr_mtl_id_map_tbl SR_MTL_ID_MAP_TBL;
774:

Line 781: ahl_workorders WO

777: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments,
778: WO.workorder_name
779: --FROM MTL_MATERIAL_TRANSACTIONS_TEMP
780: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
781: ahl_workorders WO
782: --WHERE TRANSACTION_TEMP_ID = p_txn_Id;
783: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
784: AND intf.inventory_item_id = kfv.inventory_item_id
785: AND intf.organization_id = kfv.organization_id

Line 828: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI

824: * Bug #4918991
825: */
826: /*
827: SELECT 'x'
828: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI
829: WHERE
830: DISP.INSTANCE_ID = CSI.INSTANCE_ID AND
831: DISP.WORKORDER_ID = WO.WORKORDER_ID AND
832: WO.WIP_ENTITY_ID = CSI.WIP_JOB_ID AND

Line 1733: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC

1729: -- Added project and locator for ER# 5854712.
1730: CURSOR AHL_WIPJOB_CUR (p_org_id NUMBER, p_wo_id NUMBER, p_wipjob IN NUMBER) IS
1731: SELECT A.STATUS_CODE, C.Visit_id, C.Inv_Locator_Id, C.project_id, B.project_task_id,
1732: LOC.subinventory_code
1733: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC
1734: WHERE A.WIP_ENTITY_ID = p_wipjob
1735: AND A.WORKORDER_ID = p_wo_id
1736: AND B.VISIT_TASK_ID = A.VISIT_TASK_ID
1737: AND C.VISIT_ID = B.VISIT_ID

Line 3309: FROM AHL_WORKORDERS A, AHL_VISITS_B B, AHL_VISIT_TASKS_B C

3305:
3306: -- QWuey to select the work order dependent data to be passed to Schedule materials API.
3307: CURSOR Workop_Det_Cur(p_wo_id NUMBER) IS
3308: SELECT B.VISIT_ID,C.VISIT_TASK_ID,B.PROJECT_ID,C.PROJECT_TASK_ID
3309: FROM AHL_WORKORDERS A, AHL_VISITS_B B, AHL_VISIT_TASKS_B C
3310: WHERE A.WORKORDER_ID = p_wo_id
3311: AND A.VISIT_TASK_ID = C.VISIT_TASK_ID
3312: AND C.VISIT_ID = B.VISIT_ID;
3313: --Query to select the item desccription

Line 4237: AHL_WORKORDERS b

4233: */
4234: SELECT SUM(NVL(a.net_quantity,0)) INTO l_disp_qty
4235: FROM
4236: AHL_MTL_RET_DISPOSITIONS_V a,
4237: AHL_WORKORDERS b
4238: WHERE
4239: a.workorder_id=b.workorder_id
4240: AND b.master_workorder_flag = 'N'
4241: AND b.status_code NOT IN ('17' , '22')

Line 4312: AHL_WORKORDERS W,

4308: W.wip_entity_id,
4309: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
4310: FROM
4311: AHL_MTL_RET_DISPOSITIONS_V D,
4312: AHL_WORKORDERS W,
4313: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4314: AHL_VISITS_B V,
4315: AHL_VISIT_TASKS_B VT,
4316: CS_INCIDENTS_ALL_B C,

Line 4566: AHL_WORKORDERS W,

4562: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
4563: FROM
4564: AHL_WORKORDER_MTL_TXNS T,
4565: MTL_SYSTEM_ITEMS_KFV I,
4566: AHL_WORKORDERS W,
4567: AHL_VISITS_B V,
4568: AHL_VISIT_TASKS_B VT,
4569: CS_INCIDENTS_ALL_B C,
4570: WIP_DISCRETE_JOBS WDJ,

Line 4673: AHL_WORKORDERS WO,

4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id
4671: FROM
4672: AHL_WORKORDER_MTL_TXNS TXNS,
4673: AHL_WORKORDERS WO,
4674: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4675: AHL_VISIT_TASKS_B VST_TASK,
4676: AHL_VISITS_B VST,
4677: AHL_WORKORDER_OPERATIONS WO_OP,

Line 4758: AHL_WORKORDERS E,

4754: MTL_UNITS_OF_MEASURE_VL UOM,
4755: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4756: --MTL_ITEM_LOCATIONS_KFV D,
4757: MTL_ITEM_LOCATIONS D,
4758: AHL_WORKORDERS E,
4759: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4760: AHL_VISITS_B V,
4761: AHL_VISIT_TASKS_B VT,
4762: AHL_WORKORDER_OPERATIONS F,