eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 190: FROM AHL_WORKORDER_OPERATIONS

186: AND C.VISIT_ID = B.VISIT_ID;
187: -- Cursor for Work order operation id.
188: CURSOR WO_OP_CUR(p_wo_id NUMBER, p_oper_seq NUMBER) IS
189: SELECT WORKORDER_OPERATION_ID
190: FROM AHL_WORKORDER_OPERATIONS
191: WHERE WORKORDER_ID = p_wo_id
192: AND OPERATION_SEQUENCE_NUM = p_oper_seq;
193: -- query for converting condition desc
194: CURSOR CONDITION_CUR (p_condition_desc VARCHAR2) IS

Line 1611: AHL_WORKORDER_OPERATIONS_V B,

1607: )
1608: IS
1609: SELECT COUNT(A.workorder_mtl_txn_id)
1610: FROM AHL_WORKORDER_MTL_TXNS A,
1611: AHL_WORKORDER_OPERATIONS_V B,
1612: AHL_SCHEDULE_MATERIALS C
1613: WHERE B.WORKORDER_ID=C_WRK_ID
1614: AND B.WORKORDER_OPERATION_ID=A.WORKORDER_OPERATION_ID
1615: AND B.WORKORDER_OPERATION_ID=C.WORKORDER_OPERATION_ID

Line 1723: FROM AHL_WORKORDER_OPERATIONS

1719:
1720: --Query to validate workorder operaiton id.
1721: CURSOR AHL_WORKORDER_OPER_CUR (p_wo_id NUMBER,p_op_seq NUMBER, p_woop_id IN NUMBER) IS
1722: SELECT 1
1723: FROM AHL_WORKORDER_OPERATIONS
1724: WHERE WORKORDER_OPERATION_ID =p_woop_id
1725: AND WORKORDER_ID =p_wo_id
1726: AND OPERATION_SEQUENCE_NUM = p_op_seq;
1727:

Line 1830: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B

1826:
1827: /*
1828: CURSOR TRANSACTION_DATE_CUR(C_WORKORDER_OPERATION_ID NUMBER,C_WORKORDER_ID NUMBER,C_INV_ITEM_ID NUMBER) IS
1829: SELECT A.scheduled_start_date
1830: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B
1831: WHERE A.WORKORDER_OPERATION_ID=C_WORKORDER_OPERATION_ID
1832: AND A.WORKORDER_ID=C_WORKORDER_ID
1833: AND A.WORKORDER_OPERATION_ID=B.WORKORDER_OPERATION_ID
1834: AND B.INVENTORY_ITEM_ID=C_INV_ITEM_ID

Line 3928: ,AHL_WORKORDER_OPERATIONS_V B

3924: issued NUMBER;
3925: CURSOR CUR_GET_WOID_LEVEL_QTY IS
3926: SELECT SUM(nvl(QUANTITY,0))
3927: FROM AHL_WORKORDER_MTL_TXNS A
3928: ,AHL_WORKORDER_OPERATIONS_V B
3929: WHERE A.ORGANIZATION_ID = p_org_id
3930: AND A.INVENTORY_ITEM_ID = p_item_id
3931: AND NVL(A.lot_number,'X')=NVL(p_lotnum,NVL(A.lot_number,'X'))
3932: AND NVL(A.revision,'X')=NVL(p_rev,NVL(A.REVISION,'X'))

Line 3977: -- AHL_WORKORDER_OPERATIONS_V B

3973: CURSOR CUR_GET_WO_ISSUE_QTY
3974: IS
3975: SELECT SUM(nvl(QUANTITY,0))
3976: FROM AHL_WORKORDER_MTL_TXNS A ,
3977: -- AHL_WORKORDER_OPERATIONS_V B
3978: -- JKJAIN BUG # 7587902
3979: AHL_WORKORDER_OPERATIONS B
3980: WHERE A.ORGANIZATION_ID = p_org_id
3981: AND A.INVENTORY_ITEM_ID = p_item_id

Line 3979: AHL_WORKORDER_OPERATIONS B

3975: SELECT SUM(nvl(QUANTITY,0))
3976: FROM AHL_WORKORDER_MTL_TXNS A ,
3977: -- AHL_WORKORDER_OPERATIONS_V B
3978: -- JKJAIN BUG # 7587902
3979: AHL_WORKORDER_OPERATIONS B
3980: WHERE A.ORGANIZATION_ID = p_org_id
3981: AND A.INVENTORY_ITEM_ID = p_item_id
3982: AND A.TRANSACTION_TYPE_ID =35
3983: -- AND A.ORGANIZATION_ID = B.organization_id

Line 3992: -- AHL_WORKORDER_OPERATIONS_V B

3988: CURSOR CUR_GET_WO_RET_QTY
3989: IS
3990: SELECT SUM(nvl(QUANTITY,0))
3991: FROM AHL_WORKORDER_MTL_TXNS A ,
3992: -- AHL_WORKORDER_OPERATIONS_V B
3993: -- JKJAIN BUG # 7587902
3994: AHL_WORKORDER_OPERATIONS B
3995: WHERE A.ORGANIZATION_ID = p_org_id
3996: AND A.INVENTORY_ITEM_ID = p_item_id

Line 3994: AHL_WORKORDER_OPERATIONS B

3990: SELECT SUM(nvl(QUANTITY,0))
3991: FROM AHL_WORKORDER_MTL_TXNS A ,
3992: -- AHL_WORKORDER_OPERATIONS_V B
3993: -- JKJAIN BUG # 7587902
3994: AHL_WORKORDER_OPERATIONS B
3995: WHERE A.ORGANIZATION_ID = p_org_id
3996: AND A.INVENTORY_ITEM_ID = p_item_id
3997: AND A.TRANSACTION_TYPE_ID =43
3998: -- AND A.ORGANIZATION_ID = B.organization_id

Line 4203: AHL_WORKORDER_OPERATIONS b

4199:
4200: SELECT SUM(NVL(a.primary_uom_qty,0)) INTO l_iss_qty
4201: FROM
4202: AHL_WORKORDER_MTL_TXNS a,
4203: AHL_WORKORDER_OPERATIONS b
4204: WHERE
4205: a.workorder_operation_id=b.workorder_operation_id
4206: AND a.transaction_type_id=35
4207: AND b.workorder_id=p_wo_id

Line 4218: AHL_WORKORDER_OPERATIONS b

4214:
4215: SELECT SUM(NVL(a.primary_uom_qty,0)) INTO l_rtn_qty
4216: FROM
4217: AHL_WORKORDER_MTL_TXNS a,
4218: AHL_WORKORDER_OPERATIONS b
4219: WHERE
4220: a.workorder_operation_id=b.workorder_operation_id
4221: AND a.transaction_type_id=43
4222: AND b.workorder_id=p_wo_id

Line 4320: AHL_WORKORDER_OPERATIONS O,

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,
4320: AHL_WORKORDER_OPERATIONS O,
4321: MTL_UNITS_OF_MEASURE_VL UOM,
4322: WIP_PARAMETERS WIP,
4323: MTL_ITEM_LOCATIONS_KFV L
4324: WHERE

Line 4573: AHL_WORKORDER_OPERATIONS O

4569: CS_INCIDENTS_ALL_B C,
4570: WIP_DISCRETE_JOBS WDJ,
4571: INV_ORGANIZATION_NAME_V ORG,
4572: BOM_DEPARTMENTS B,
4573: AHL_WORKORDER_OPERATIONS O
4574: WHERE
4575: T.ORGANIZATION_ID = V.ORGANIZATION_ID
4576: AND T.WORKORDER_OPERATION_ID = O.WORKORDER_OPERATION_ID
4577: AND W.WORKORDER_ID = O.WORKORDER_ID

Line 4677: AHL_WORKORDER_OPERATIONS WO_OP,

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,
4680: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4681: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,

Line 4762: AHL_WORKORDER_OPERATIONS F,

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
4766: AND A.WORKORDER_OPERATION_ID=F.WORKORDER_OPERATION_ID

Line 5118: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o

5114: AND NVL(ACTIVE_END_DATE,SYSDATE))
5115: /* fix for bug# 6310766: extra row being displayed with 0 qty
5116: -- split this query into two to handle serialized and non-serialized items.
5117: AND NOT EXISTS (SELECT 'x'
5118: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o
5119: where txn.workorder_operation_id = o.workorder_operation_id
5120: and o.workorder_id = w.workorder_id
5121: and txn.instance_id = csi.instance_id
5122: and txn.TRANSACTION_TYPE_ID = 35)

Line 5126: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o

5122: and txn.TRANSACTION_TYPE_ID = 35)
5123: */
5124: -- for serialized items
5125: AND NOT EXISTS (SELECT 'x'
5126: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o
5127: where txn.workorder_operation_id = o.workorder_operation_id
5128: and o.workorder_id = w.workorder_id
5129: and txn.instance_id = csi.instance_id
5130: and txn.TRANSACTION_TYPE_ID = 35

Line 5138: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o

5134: --and txn.inventory_item_id = csi.inventory_item_id
5135: )
5136: -- for non-serialized items
5137: AND NOT EXISTS (SELECT 'x'
5138: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o
5139: where txn.workorder_operation_id = o.workorder_operation_id
5140: and o.workorder_id = w.workorder_id
5141: and txn.TRANSACTION_TYPE_ID = 35
5142: and txn.serial_number is null