APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 3000: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo

2996: -- To get latest material issue txn for the item instance.
2997: CURSOR ahl_mtl_txn_csr (p_Item_Instance_Id IN NUMBER,
2998: p_workorder_id IN NUMBER) IS
2999: SELECT workorder_mtl_txn_id
3000: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo
3001: WHERE mt.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3002: AND TRANSACTION_TYPE_ID = 35 -- issues.
3003: AND woo.workorder_id = p_workorder_id
3004: ORDER by mt.TRANSACTION_DATE DESC, mt.LAST_UPDATE_DATE DESC;