APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_VISIT_TASKS_B

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 247: --AHL_VISIT_TASKS_B VT,

243: A.WIP_ENTITY_ID
244: FROM
245: AHL_SEARCH_WORKORDERS_V A
246: --AHL_VISITS_B V,
247: --AHL_VISIT_TASKS_B VT,
248: --INV_ORGANIZATION_NAME_V ORG,
249: --FND_LOOKUP_VALUES WO_STS
250: WHERE
251: A.JOB_NUMBER = C_WORKORDER_NAME

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 4315: AHL_VISIT_TASKS_B VT,

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,
4317: WIP_DISCRETE_JOBS WDJ,
4318: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
4319: BOM_DEPARTMENTS B,

Line 4568: AHL_VISIT_TASKS_B VT,

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,
4571: INV_ORGANIZATION_NAME_V ORG,
4572: BOM_DEPARTMENTS B,

Line 4675: AHL_VISIT_TASKS_B VST_TASK,

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,
4678: MTL_SYSTEM_ITEMS_KFV MTL,
4679: MTL_UNITS_OF_MEASURE_VL UOM,

Line 4761: AHL_VISIT_TASKS_B VT,

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,
4763: WIP_PARAMETERS W
4764: WHERE
4765: A.INVENTORY_ITEM_ID=B.INVENTORY_ITEM_ID